topic Error While Opening an Excel using VBO in Product Forum

Error While Opening an Excel using VBO

MaxHermans — Mon, 08 Feb 2021 09:35:40 GMT

While Opening an Excel using VBO , Open work Book in BP Version 6.8.1 am getting this error , Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation.

I configured the input and outputs of the action stages correctly and I still get an error. (See attachment for error)

All help is appreciated!!

Thanks in advance

Re: Error While Opening an Excel using VBO

RobinToll — Mon, 08 Feb 2021 09:38:29 GMT

Hey Max,

This is a problem that has a lot of potential causes, but at the core of it what that error means is that Excel is refusing to run the call that BP is making. It could be permissions, version incompatibility, .NET framework problems, language/cultural settings, or other things. Please take a look at this and see if any of the suggestions here help:

https://portal.blueprism.com/customer-support/support-center#/path/Automation-Design/Studio/Code-Stages/1158824822/How-do-I-fix-error-Exception-has-been-thrown-by-the-target-of-an-invocation-when-running-a-Process.htm

Thank you very much,
-Robin Toll
Senior Technical Consultant
Blue Prism Professional Services

Re: Error While Opening an Excel using VBO

JerinJose — Mon, 08 Feb 2021 09:39:15 GMT

Hi Max,
can you check the culture setting on your MS excel VBO?. follow this KBs for a work around. http://portal.blueprism.com/customer-support/support-center#/path/1211660442

http://portal.blueprism.com/customer-support/support-center#/path/1301681772

let us know if it solves your problem.