Question
Automation with Excel Macro not executing
Hi Pega community, I've created a simple automation which opens 2 Excel files and should execute a macro contained within one of the files. When I run the automation I receive the following error:
Error executing link in Automation: RunMacro - From: Windows_Form1.btnRunMacro.Click To: Global_Container1.AttachmentIndex.RunMacro()
Cannot run the macro 'SyncadaImport'. The macro may not be available in this workbook or all macros may be disabled.
I also receive extended details on the error which are attached. Can anyone suggest ways to overcome this issue? Thanks in advance.
The error message says it can't run the macro and that may be due to a security restriction. Check the macro settings in the Trust Center to make sure they are not disabled.