Hello,
I’m getting the following error message when I try to run my robot:
“Run Spreadsheet Macro: Cannot run the macro ‘A_ImportTemplateAndClearOutOldData’. The macro may not be available in this workbook or all macros may be disabled.”
I’ve tried researching the solution to this question elsewhere but I think all other solutions are only applicable to earlier versions of UiPath(ie saying I should use “invoke VBA”), so I think I need a new solution.
I’ve included a screenshot of the UiPath workflow below to show which activities I’m using.
Things I’ve tried/verified:
- I’ve enabled All macros in the excel workbook
- the workbook i’m using is an XLSM file type
- in my trust center settings, i’ve made sure that “Trust Access to the VBA project object model” option IS checked.
- I’ve been able to initiate the macros in the file myself by manually kicking them off(not a problem with the macro itself.
I did notice that the “Project_Notebook” has been popping up after I start up the robot, so I don’t know if that’s potentially interfering with the robot from initiating the macro.
Any help would be greatly appreciated!