How to run "Execute Macro" activity?


#1

Why is this error coming?


Could somebody give me a sample how to use Execute Macro with output parameter?
#2

Hi,

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

Regards,
Ranjith.


#3

Hi,

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


#4

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.


#5

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.

image


#6

hi,
pls follow below tutorial,

thanks,
Karthik.


#7

Hi @asishkumar,

May I know the situation to use the macro ?

Regards
Balamurugan.S


#8

Hi Balupad,

Well there are number of scenario where we can use macros, basically as part of back office automation where we needs to run macro.

  1. If the excel macro is part of the Automation process
  2. We can also write custom macro when we needs to perform some basic calculation or validation or reconciliation of the data in excel file.

Thanks,
Asish