Digital Exchange

 View Only
last person joined: 2 days ago 

This community is a place to discuss Blue Prism DX assets and development.

  • 1.  Facing an issue in Move Worksheet - MS Excel VBO

    Posted 22 days ago

    Hi team,

    I'm facing the below error while trying to copy a worksheet from one workbook to another workbook. I'm using the latest MS Excel VBO from DX.

    I'm passing True in Copy flag since the action name says Move Worksheet but also has a flag exposed to only copy(should rename this action to Move/Copy Worksheet)

    I have both workbooks opened.

    Tried different scenarios here but could not find a solution to this error. 

    Any help would be appreciated.



    ------------------------------
    If I was of assistance, please vote for it to be the "Best Answer".

    Thanks & Regards,
    Tejaskumar Darji
    Sr. Consultant-Technical Lead
    ------------------------------


  • 2.  RE: Facing an issue in Move Worksheet - MS Excel VBO

    Posted 21 days ago

    Hello @Tejaskumar Darji - I have tried replicating that with one of my extended actions in MS Excel VBO Extended object - I was able to move sheet at said index from source Excel workbook to the primary Excel workbook.

    I have attached the release alongside for object just check if you can see and compare with your own MS Excel VBO, let me know if you face any difficulties in executing it.



    ------------------------------
    Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

    Regards,

    Mukesh Kumar - Senior Automation Developer

    NHS England, United Kingdom, GB
    ------------------------------

    Attachment(s)

    xlsx
    Test Source WorkSheet.xlsx   8 KB 1 version
    xlsx
    Test 1 WorkSheet.xlsx   12 KB 1 version
    bprelease
    MS Excel Extended Test VBO.bprelease   491 KB 1 version
    Original Message


  • 3.  RE: Facing an issue in Move Worksheet - MS Excel VBO
    Best Answer

    Posted 21 days ago

    Additionally I did try with the most latest version I could find out from DX with download link as : https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo, and I was able to move the worksheet with this VBO as well.

    You should pass the Destination Position as 1 as index starts from 1 in MS Excel (Ref - Sheet1 by default), let me know if you face the error again !! with these changes.



    ------------------------------
    Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

    Regards,

    Mukesh Kumar - Senior Automation Developer

    NHS England, United Kingdom, GB
    ------------------------------

    Original Message


  • 4.  RE: Facing an issue in Move Worksheet - MS Excel VBO

    Posted 18 days ago

    It got finally resolved. The issue was with the way I was opening the other PDF. I was creating 2 separate handles and opening both excel individually before doing copy worksheet but after seeing your snapshot I directly opened another workbook in the same handle. Now able to copy worksheets.

    Thanks @Mukesh Kumar 



    ------------------------------
    If I was of assistance, please vote for it to be the "Best Answer".

    Thanks & Regards,
    Tejaskumar Darji
    Sr. Consultant-Technical Lead
    ------------------------------

    Original Message


Related Content

Welcome to the Blue Prism Digital Exchange Community!

The Blue Prism Digital Exchange is a "shop window" for new and emerging technologies—a platform that puts powerful RPA and AI capabilities into the hands of business leaders. Users can find and apply pre-built AI capabilities, in the form of downloadable integrations and Visual Business Objects (VBOs), to automated processes. These assets connect and integrate Digital Workers, existing systems and processes to Blue Prism's technology partners, creating a solid foundation of AI-enabled Intelligent Automation that's scalable and sustainable.

Blue Prism Digital ExchangeDX Asset IdeasContact DX Support

FAQs

The Blue Prism Digital Exchange (DX) is an online marketplace where businesses can instantly access, apply and share pre-built AI, cognitive and advanced RPA technologies from best-in-class providers. These assets easily connect to existing digital workers, systems and processes to enhance automation capabilities.
The Digital Exchange is free to all users. Most of the content on the DX is free to download but there are some submissions that do have a cost associated. The submissions with a cost are advertised on the asset card and profile. No unwanted costs will be applied to any users.
You can visit and browse the Digital Exchange here. If you would like to consume or download any material it is necessary to create an account on the Blue Prism Portal first.
Everyone can access the Digital Exchange and consume the assets on it. If you would like to contribute to the marketplace it is necessary that you create an account and sign up as a partner.