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	1746	November 14, 2021
How to remove filters for a specific excel sheet Studio excel , uiautomation , activities , studio , question	1	855	May 21, 2021
How to Remove Excel Filters using UiPath? Studio	5	2445	October 16, 2022
Studio does not recognise Excel filter Activities excel , activities , question	5	634	January 7, 2021
How to pass a variable to an "Invoke VBA" script? Studio studio , question , activities_panel	5	2772	July 22, 2021

Most Active Users - Yesterday
Anil_G
NIVED_NAMBIAR
sesa499170
class_materials
ashokkarale
Anelisa_Bolosha1
naveen.s
eray_atasoy
Aniesah_Malong
SACHIN_BILE1
More details...

How To Clear Filters in Excel

Related Topics