Question

An error occurred in task : \Bots\xxxxxx at line number : 14 with error description : Cannot run the macro 'xxxx'. The macro may not be available in this workbook or all macros may be disabled.

  • 22 April 2022
  • 2 replies
  • 17 views

Environment - Win 10,

Excel ver "Microsoft®️ Excel®️ for Microsoft 365 MSO (Version 2201 Build 16.0.14827.20216) 64-bit ",

AA Ver "Automation 360 build 12342", Bot agent Ver "21.134"

 

Issue - My bot is not able to hit a call VBA macro in xlsm file.

The message it shows is “Cannot run the macro 'abc'. The macro may not be available in this workbook or all macros may be disabled.”

 

Diagnosis : 1- Almost all excel security / permission including Trust Centre permutation combinations.

2 -Nothing at Event viewer logs.

3 -Open Program file command is not very useful its just a work around.

4 -Reinstalled AA bot agent 😞 ..

5 - 2 calls with AA guys

 

Conclusion: still facing same message + does win 10 need some additional patch for advance excel. OR AA need any add on. OR calling macro is a problem always.

 image.pngimage.png 


2 replies

Userlevel 4
Badge +8

@Amit Gupta​  : we kindly request you raise a support case or Please email support team at support@automationanywhere.com to address this issue 

Create a module and write then create a Sub in the module, save the excel file as .xlsm.

 

At the time of calling the excel ,macro from AA Bot, the run excel macro command, user <moduleName>.<sub name>

 

like. in excel file Input.xlsm, you have added a module called my modTest, and added a sub called add

 

Then at the time of calling the macro from AA's runExcel command user modTest.add

 



Reply