hi,
i got a solution for it from bluePrism.
You may encounter a scenario where the MS Excel VBO is not opening the Excel workbook. The VBO works if the language settings are English but doesn’t work with any other language setting, instead failing with the following error:
“Internal: Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation. "
How to resolve this issue
Perform the following steps:
- Access the MS Excel VBO.
- On the Initialise tab, double-click on the MS Excel VBO to access the business properties.
- Select the Global Code tab.
- Once in the Global Code, replace the culture parameter with Nothing in the Invoke, SetProperty, and Get Property methods (highlighted below):
It worked for me.
Best regards,
Susheel