topic usage of Run Macro in Product Forum

usage of Run Macro

Sai_SrinivasGS — Wed, 18 Dec 2019 15:33:00 GMT

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
------------------------------

RE: usage of Run Macro

Carl__Carter — Thu, 19 Dec 2019 10:29:00 GMT

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
------------------------------

RE: usage of Run Macro

vivek.kumar.goel — Fri, 20 Dec 2019 03:55:00 GMT

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.
------------------------------

RE: usage of Run Macro

expertcr — Tue, 25 Apr 2023 14:59:00 GMT

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

Example of two Excel files; one with macro-enabled.

------------------------------
Luis Lopez
Customer Support Engineer English and Spanish
Blue Prism Ltd
------------------------------