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.
When you say enable ActiveX, how do I go about doing that?
I also just tried running the robot on a local file, but that didn’t work. I also updated the Sequence as you recommended: Excel process scope → use excel file → run spreadsheet macro, but those didn’t address the problem.
I actually figured out what you were referring to with ActiveX. I just updated that in my settings(screenshot below), but i’m still getting the same error message. Any other ideas as to what’s causing the error?