topic I restarted my PC, in Product Forum

Error using the MS Excel VBO

PatrickMueller — Tue, 07 Nov 2017 19:18:00 GMT

Hi everyone, I am facing the following issue: We are getting an error message every time we call the Action "Open Workbook" from BO MS Excel VBO which came with the version 5.0.33.0 We always get: ERROR: Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation. It does not matter if we try to access xls or xlsx or even plain csv €“ that exception is thrown and we cannot find any hint about what the issue could be. The version we are using is 5.0.33.0 & .Net Framework 4.0.30319.42 installed on Windows Server 2012 R2 with Microsoft Office Professional Plus 2016 The funny thing is we have an identical installation where it works without any issue. I already opened a support ticket with BP but they were not able to help me there - also checking the EventLogs and BP Logs did not show any entries. We have already tried to un- and re-install the .Net Framework and Office but with the same result. Hope anyone can help me to find the actual issue.

Hello,

Denis__Dennehy — Tue, 07 Nov 2017 19:30:00 GMT

Hello, Support for Office 2016/365 is on the roadmap. It is likely to be supported by the end of the year/beginning of next year. For new versions of Office or Windows OS or Micosoft SQL Server etc. I recommend keeping an eye on our product release notes and not using them as part of your Blue Prism platform until the have been certified for use.

Hi,

MadsMeyer — Tue, 07 Nov 2017 23:43:00 GMT

Hi, We have the same issue. It has worked with Excel 2016 but suddenly it stopped working. Any help on how to fix this or what the issue could be?

Hi,

MadsMeyer — Tue, 07 Nov 2017 23:44:00 GMT

Hi, We have the same issue. It has worked with Excel 2016 but suddenly it stopped working. Any help on how to fix this or what the issue could be?

I really hope to get some

PatrickMueller — Thu, 09 Nov 2017 19:11:00 GMT

I really hope to get some help here - I really don't know what to do - it is working on some machines - is there any .NET log that can be checked - unfortunately in the Event Viewer there is no entry at all....

Have you found any solution?

DamianStankiewi — Wed, 22 Nov 2017 13:50:00 GMT

Hi, have you found any solution? I have the same issue. Already tried a couple of methods for loading from Excel and nothing works. The workaround I used is to get the source data in CSV and use Utility - File Management ""Get CSV Text As Collection"". But it doesn't solve the problem itself.

Try to restart your PC ;) I

AnatoliyBanniko — Wed, 22 Nov 2017 19:53:00 GMT

Try to restart your PC 😉 I had same problem, it helped.

I restarted my PC,

DamianStankiewi — Thu, 23 Nov 2017 19:26:00 GMT

I restarted my PC, reinstalled Office and BluePrism and nothing helped so far. This weekend I'll try to repair Windows, maybe one of the system files got corrupted? 😕

Yes restarting doesn't change

PatrickMueller — Mon, 27 Nov 2017 20:18:00 GMT

Yes restarting doesn't change anything...do you have SQLExpress installed on that machine as well ? I did some testing...clean Windows 2012 R2 installation and BluePrism and a Remote SQL Instance - it works - both with Office 2013 and Office 2016....once I install SQL Express and create a local instance of the DB it stops working....

I didn't try Patrick's

Anonymous — Tue, 28 Nov 2017 15:24:00 GMT

I didn't try Patrick's solution, but got my own - in my case the problem was with Excel VBO from BluePrism versions 5.0.32 and 5.0.33. If you use Excel VBO from version 5.0.30 or older it works like a charm. 🙂

Hello Jacek,

RajathGopal — Tue, 28 Nov 2017 18:12:00 GMT

Hello Jacek, I am using SQL Server 2016 and BluePrism version 5.0.23 with .Net 4.0.30319.42 and Office 2013 still the same issue. I mean the first time when I ran the object it worked a charm and the next time I run it just crashes with the exception

I'm having the same issue,…

MarcelaMesa — Mon, 05 Feb 2018 04:28:00 GMT

I'm having the same issue, with Windows Server 2012... I'm not sure what to check to fix it. Have you guys resolved this?

HI Team, i have the same…

Gustavo_Alfredo — Tue, 17 Jul 2018 03:26:00 GMT

HI Team, i have the same issue, ""Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation."" SQL Express 2017 , Excel 2013