Hi, I am attempting to clear filters on multiple Excel sheet. I want to clear the filters so all data is shown for each sheet in the workbook. The print screen shows the code I have defined for Invoke VBA Code with ActiveSheet defined as Inbound Argument. I am unsuccessful on how to pass the name o…

HI @randy.stokes Try these steps Excel application scope Get workbook sheets store in sheets For each item in Sheets Invoke vBA parameter as Item.ToSTring Method 2: Enable modern in the activities panel [image] Steps will be like Excel application scope Get workbook sheets sto…

How To Clear Filters in Excel

Help Studio

Gokul001 (Gokul Balaji) October 10, 2022, 1:19pm 3

Hi @randy.stokes

Check out this thread

Regards
Gokul

1 Like

Topic		Replies	Views
Remove filters from excel using invoke code Activities excel , activities , question , invoke-code	2	1885	November 14, 2021
How to remove filters for a specific excel sheet Studio excel , uiautomation , activities , studio , question	1	948	May 21, 2021
How to Remove Excel Filters using UiPath? Studio	5	3551	October 16, 2022
Studio does not recognise Excel filter Activities excel , activities , question	5	667	January 7, 2021
How to pass a variable to an "Invoke VBA" script? Studio studio , question , activities_panel	5	3875	July 22, 2021

How To Clear Filters in Excel

Related topics