Trigger Macro issue in SAP IRPA

[suvendub98]

Hi,

I'm trying to trigger a macro in SAP IRPA using the "Trigger Macro" activity, but getting the below error:

"The macro InsertPivotTable has failed. The error message is : Cannot run the macro 'C:\\Automation Projects Execution\\Mosaic\\Weekly pivot details.xlsm!InsertPivotTable'. The macro may not be available in this workbook or all macros may be disabled. DispInvoke: Run Exception occurred.\r\n",

Any help is appreciated.

Thanks.

[wuttichai_s]

Please try running the macro 'InsertPivotTable' directly from Excel first to confirm that it works properly without using SAP IRPA. @suvendub98 

[suvendub98]

Thanks for your response. I have fixed the problem.