Why is this error coming?
Could somebody give me a sample how to use Execute Macro with output parameter?
Run the macro with prefix as “ThisWorkbook.YourMacroName” in Execute Macro Activity and enable the macro warning if it is shown while opening the worksheet manually.
If it doesnt works,Refer this post
We struggle wth the same issue.
We put the name on the macro and when it’s run we have error message Message: The range does not exist
Have you tried removing “PERSONAL.XLSB!” from the MacroName?
Where it says “PERSONAL.XLSB” in the macro name, have you tried using the full filepath?
I’m not sure but thought maybe one of the two could fix it.
This error is coming as UiPath is unable to read the macro name from the xlsm (macro) file.
You can design the workflow like this, which will resolve the problem.
Here TestMacro is the Name of target macro which we wanted to execute from the xlsm file.