Question
Serendebyte Inc
US
Last activity: 6 Nov 2018 20:02 EST
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.
Pegasystems Inc.
US
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.
Serendebyte Inc
US
Hi Jeff, I opened up the trust settings on Excel and when I run I get past the posted issue and get a runtime 9 error. Thanks!
Pegasystems Inc.
US
I am not sure what that is, but I suspect that is coming from the macro itself. What happens when you run the macro manually?
Serendebyte Inc
US
The macro's purpose is to copy some data from one file into the other among other text edits. I think the macro is having a hard time understanding the that the second worksheet needed is open when the files are launched by the automation because I get a similar error if the second file is not open when running in Excel directly. I also get a second error from the automation side after the runtime error 9 like below and with details attached.
Error executing link in Automation: RunMacro - From: Windows_Form1.btnRunMacro.Click To: Global_Container1.AttachmentIndex.RunMacro()Exception from HRESULT: 0x800A9C68
Pegasystems Inc.
US
The exception that the automation is returning is just a generic exception from the macro. Without more info it would be hard to say how to fix this. At least you know the source of the problem.