topic RE: Open Workbook Excel VBO and Open Connection Oledb in Product Forum

Open Workbook Excel VBO and Open Connection Oledb

RitikAnand — Mon, 09 Nov 2020 06:25:00 GMT

Hi,
I am working on an excel where I am first getting data using Oledb. Then without closing connection, in next Page I am creating instance and doing Open Workbook which is giving error as Excel is already open. It was working on BP v5 but giving this error in BP v6.5. Is there a way to Open Excel Workbook and have a Oledb connection at same time in v6.5?
The excel has macros. We don't want to do Close connection and Open workbook each time because it is will take a lot of time.

Thanks

------------------------------
Ritik Anand
Senior Analyst
Capgemini
Asia/Kolkata
------------------------------

RE: Open Workbook Excel VBO and Open Connection Oledb

david.l.morris — Mon, 09 Nov 2020 13:58:00 GMT

Why would it take a lot of time to Close the connection and Open workbook each time? Are you doing that a lot of times?

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------

RE: Open Workbook Excel VBO and Open Connection Oledb

RitikAnand — Mon, 09 Nov 2020 14:47:00 GMT

Yes. The bot will process around 1000 rows of data each day. And it needs to update excel for most of them.

------------------------------
Ritik Anand
Senior Analyst
Capgemini
Asia/Kolkata
------------------------------

RE: Open Workbook Excel VBO and Open Connection Oledb

ewilson — Mon, 09 Nov 2020 15:44:00 GMT

@RitikAnand are you working with different workbooks in both cases (OLEDB is pulling data from Workbook A and then Excel VBO is trying to work with Workbook B) or the same workbook (OLEDB and Excel VBO are both trying to work with Workbook A)?

Also, which Excel VBO are you using? The Blue Prism standard VBO, the Extended VBO (available on the DX), or one of our partner VBOs?

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Open Workbook Excel VBO and Open Connection Oledb

RitikAnand — Mon, 09 Nov 2020 17:30:00 GMT

I am working on same excel workbook. I am using the standard Excel and Oledb VBOs.

------------------------------
Ritik Anand
Senior Analyst
Capgemini
Asia/Kolkata
------------------------------

RE: Open Workbook Excel VBO and Open Connection Oledb

BalazsRoman — Mon, 09 Nov 2020 18:24:00 GMT

@RitikAnand I'd create a copy of the file and use it for OLEDB and use the standard Excel functions on the original workbook.

------------------------------
Balazs Roman
Junior RPA Consultant
human+
Europe/London
------------------------------

RE: Open Workbook Excel VBO and Open Connection Oledb

ewilson — Mon, 09 Nov 2020 18:59:00 GMT

I just ran a quick test of opening a workbook with the OLEDB VBO, pulling the contents of Sheet1, moving to a new page and using the Excel VBO to open an instance and pull the contents of the same sheet, and then moving back to the original page to close the OLEDB connection. Seems to work fine with no errors.

What connection string are you using for setting up your OLEDB connection?

As Balazs mentions in his reply, it might be best to try and split this across copies so you don't accidentally create a memory corruption or something, but from what I see it seems to work.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------