Excel macro cannot run or doesn't exist

rob.j · December 3, 2018, 9:04pm

Hi, I have got bot that is running on Windows 8 and at one point execute Excel (2013) macro. However once bot has been moved to Windows 10 Excel (2016) machine I get an error message that macro cannot be run or doesn’t exists (System.Runtime.InteropServices.COMException). If I run excel macro on its own there isn’t any issue. Any advice would be appreciated. Thanks

aisling.bai · December 4, 2018, 1:13am

Hi,

I’m also facing this issue, however I suggest you to check the Excel trust center setting – macro setting. My company sets it as “Disable all the macro…” and I can’t change it, I think this may be the reason. You can just compare the settings between Excel (2013) and Excel (2016).

Thanks,
Aisling

rob.j · December 4, 2018, 8:05am

Hi Aisling,
Thank you for reply. That was my first thought, however in my case enable all macros and trust all is selected.

Topic		Replies	Views
When the Bot ran it is giving the Error: Could not find the macro or all the macros are disabled Studio excel , question	4	799	April 14, 2023
UiPath raise 'Cannot run the macro . The macro may not be available in this workbook...' error Activities excel , activities , question	3	2140	May 3, 2022
<Excel VBA> Invoke VBA: Cannot run the macro 'PC_Exists_in_SAP'. The macro may not be available in this workbook or all macros may be disabled Studio uiautomation , activities , excel-automation , excel-vba	5	20954	September 26, 2023
Macro issue - Cannot run the macro. the macro may not be available in this workbook or all macros may be disabled Studio datatable , excel , uiautomation , question , macros , vba-code , vba-excel-macros	3	762	January 25, 2024
Cannot run the macro 'Macro3'. The macro may not be available in this workbook or all macros may be disabled Help	4	8280	November 17, 2020

Excel macro cannot run or doesn't exist

Related topics