Remove filters from excel using invoke code

Help Activities
, , ,
2

Hi @berkaykor

We can use vba for this (put the code in a text file and call in invoke vba activity,

Sub Filter()
    if ActiveSheet.AutoFilterMode then
       Cells.AutoFilter
    end if
End Sub

Please refer this for how to use invoke vba activity,

Or you can also try the balareva package for removing the filter with a activity)

Thanks

1 Like