topic RE: Facing an issue in Move Worksheet - MS Excel VBO in Digital Exchange

Facing an issue in Move Worksheet - MS Excel VBO

Tejaskumar_Darji — Thu, 09 Mar 2023 17:27:00 GMT

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
------------------------------

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

Mukeshh_k — Thu, 09 Mar 2023 19:19:00 GMT

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
------------------------------

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

Mukeshh_k — Thu, 09 Mar 2023 19:36:00 GMT

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.

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

Tejaskumar_Darji — Mon, 13 Mar 2023 10:06:00 GMT

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
------------------------------