Hi All,
I am running into some reliability issues when using the 'Run Macro' function in the Excel VBO. This may specifically relate to instance of excel that have been previously opened, where the process is attaching to the instance.
Right now my process works as follows:
Process #1 opens and runs a macro in an excel workbook. That macro generates an email that users will provide a response to. The process detaches from the workbook and leaves it open on the resource PC. When the user responds, Process #2 attaches to the workbook and runs a second macro which finishes the job and closes the workbook.
It seems that BP is not executing the macro on the Process #2 consistently. According to the logs, the macro is getting called with no errors, but that does not seem to be happening in reality. Right now, I would estimate that the BP fails to run the macro 5-10% of the time, so it doesn't seem to be a syntax issue. Has anyone ever experienced this before, or possibly have an idea on how to approach confirming that the macro has actually run before moving on to the next stage?
Right now my best idea is to attempt to run a macro that does not exist in the workbook , catch the error and then proceed to try to run the real macro. At least then I'll know that it has successfully attached to the workbook and hopefully it will run the real macro.
