I want to filter excel using auto filter mode.
Here is the code that i have written in VBA or excel marcos.
How to use this code in Uipath using
2. invoke VBA
3. invoke VbScript.
Dim data_sh As Worksheet
Set data_sh = ThisWorkbook.Sheets(“Sheet1”)
data_sh.AutoFilterMode = False
data_sh.UsedRange.AutoFilter 1, Array(“john”, “Stan”), xlFilterValues
Any expert please guide either using any one the three method or it would be great if you can guide for all 3.
This will really help a lot for newbie.
Any expert please look into this.