cancel
Showing results for 
Search instead for 
Did you mean: 

usage of Run Macro

Sai_SrinivasGS
Level 3
Hello,
I am using action Run Macro , Gave handle and Macro Name but it is throwing error. Macro is available in the workbook, Please find attached screenshots

------------------------------
Sai Srinivas GS
------------------------------
3 REPLIES 3

Carl__Carter
Staff
Staff
Hi Sai,

Looking at your process flow, you have enclosed the Macro name in quotes and stored this in a Data Item. The value of Data Item is "Macro1".

The Macro name is Macro1 and not "Macro1", therefore drop the quotes from the Data Item value,

Hope this helps.

------------------------------
Carl Carter
Developer Program Manager
Blue Prism
Europe/London
------------------------------

VivekGoel
Level 10
Just change the macro name to contain without quotes inside the data item.

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
https://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------

Remember is not just that you add quotes in the name of the macro; it is also that you save your Excel file with macro-enabled; that is why your process fails to find the macro in the Excel file.

Also, when saving with macro-enabled, the file name change from XLSX to XLSM

29939.png

Example of two Excel files; one with macro-enabled.
29940.png
------------------------------
Luis Lopez
Customer Support Engineer English and Spanish
Blue Prism Ltd
------------------------------