Hello,
Sorry if this is a simple ask. I am trying to run a flow with Excel macros, but whenever I try to run it, I get the error message:
"Failed to run macro (make sure the macro containing file isn't included in the disabled items list).".
I've checked that the macros are available in Personal.XLSB. How do I enable disabled items? And how do I get these macros to show up in PAD?
Thanks!
Solved! Go to Solution.
Hi,
In the Macro parameter of the "Run Excel Macro" action, you must specify the XLSB name and macro name, such as "PERSONAL.XLSB!Macro1".
Regards,
kinuasa
Save your Personal.XLSB to a new MacroWorkbook.xlsm and create all new macros in this workbook. That way you can reference this workbook when you need to and they will all be available.
Hi,
In the Macro parameter of the "Run Excel Macro" action, you must specify the XLSB name and macro name, such as "PERSONAL.XLSB!Macro1".
Regards,
kinuasa