I have written one macro stored in one abc.xlsm file. That macro is doing some activity on xyz.xls file. Now i am calling the macro using excel app scope passing abc.xlsm…it is not doing the operations on xyz.xls file…Can anyone is aware of this issue?
Does your macro work when you activate it within the spreadsheet itself without using UiPath?
See this sample -
Main.xaml (6.4 KB)
Also that is right your worksheet must be macro enabled. And you just have to use name of the Macro not extension while calling like this