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.