Blue Prism Product

 View Only
last person joined: 9 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  Open Workbook Excel VBO and Open Connection Oledb

    Posted 11-09-2020 06:25
    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
    ------------------------------


  • 2.  RE: Open Workbook Excel VBO and Open Connection Oledb

    Posted 11-09-2020 13:58
    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
    ------------------------------

    Original Message


  • 3.  RE: Open Workbook Excel VBO and Open Connection Oledb

    Posted 11-09-2020 14:47
    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
    ------------------------------

    Original Message


  • 4.  RE: Open Workbook Excel VBO and Open Connection Oledb

    Posted 11-09-2020 15:44
    @Ritik Anand 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
    ------------------------------

    Original Message


  • 5.  RE: Open Workbook Excel VBO and Open Connection Oledb

    Posted 11-09-2020 17:30
    I am working on same excel workbook. I am using the standard Excel and Oledb VBOs.

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

    Original Message


  • 6.  RE: Open Workbook Excel VBO and Open Connection Oledb

    Posted 11-09-2020 18:24
    @Ritik Anand 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
    ------------------------------

    Original Message


  • 7.  RE: Open Workbook Excel VBO and Open Connection Oledb
    Best Answer

    Posted 11-09-2020 18:59
    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
    ------------------------------

    Original Message


Related Content

Welcome to the Blue Prism RPA Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering
Product Research ProgramUpdates, Releases & Announcements

FAQs

Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism RPA can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism RPA can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.