Running Excel macros

[TCM]

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!

[MichaelAnnis]

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.

[kinuasa · Accepted 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