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 elsewh…

Hi Anil, I figured it out! I had saved my macros under a certain spreadsheet as opposed to putting them in a Module. I guess I wasn’t being detailed enough with my descriptions. So I should have originally listed my macro as “Sheet1.A_ImportTemplateAndClearOutOldData” instead of “A_ImportTemplateA…

@Thomas.Dettmer Please try enabling activex as well… And also I see it is a network location…to check can you try by moving to local… And generally the sequence of excel is Excel process scope → use excel file → run spreadsheet macro Cheers

Hi Anil, Thanks for your reply. 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 addr…

Hi Anil, 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? Thanks! [Capture]

"Run Spreadsheet Macro" saying that I Cannot run the macro

Help Studio

Hiba_B (Hiba Beldi) January 15, 2023, 10:57pm 6

That’s great to know: thank you for the tips !
Don’t forget to mention your answer as the solution, so the thread closes and thus helps other users

1 Like

Forum Engagement Daily Reports

Topic		Replies	Views
Execute Macro Doesn't work Studio excel , activities	5	1390	October 6, 2021
<Excel Macro Issue> Invoke VBA - Macro1: Cannot run the macro 'Macro1'. The macro may not be available in this workbook or all macros may be disabled Studio vba , macros , excel-automation , vba-excel-macros	7	1514	February 2, 2024
Macro excel is properly working on my side, but the other user cannot run it Studio uiautomation , uipath , uipath_macroexcel	12	11947	November 8, 2023
Run macros from Excel file using Invoke VBA Studio studio	1	1054	October 2, 2020
Cannot run the macro 'Macro3'. The macro may not be available in this workbook or all macros may be disabled Help	4	8336	November 17, 2020

"Run Spreadsheet Macro" saying that I Cannot run the macro

Related topics