topic RE: I think you also need to open in Product Forum

MS Excel VBO Copy And Paste

Anonymous — Sat, 22 Oct 2016 03:33:00 GMT

MS Excel VBO Copy And Paste action giving 'Failed to copy worksheet: Invalid Index' error. Please guide. Thanks. Soumya

Invalid Index means it thinks

RobinToll — Tue, 25 Oct 2016 22:35:00 GMT

Invalid Index means it thinks you're telling it to either copy or paste to a row/column that doesn't exist. Try checking your indexes against the actual data and make sure you're referencing rows and columns which actually exist in the file. Thank you, -Robin Toll

I am trying to Copy and Paste

suchit_tripathy — Sun, 06 Nov 2016 18:48:00 GMT

I am trying to Copy and Paste two rows from one excel file to another excel file by using EXCEL VBO with the action ""Copy and Paste Worksheet Range"" but getting the error : Failed to copy worksheet: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

I think you also need to open

RadoslavHiko — Wed, 09 Nov 2016 13:37:00 GMT

I think you also need to open both Excel files under the same Excel instance.

RE: I think you also need to open

Sharath_KumarPe — Thu, 22 Aug 2019 16:06:00 GMT

I was facing the issue and able to solve it by following the below steps.

1. Create Instance
2. Open SourceWorkbook -- Output you write to some data item called WorkBookName1
3. Open DestinationWorkbook -- Output you write to some data item called WorkBookName 2
4. Show
5. Copy and Paste worksheet range Action (Parameters are the key here)
handle
SourceWorkBook name = WorkBookName1 (This is the output variable of step 2) --- Do not pass Full file path name here
DestinationWorkBook name = WorkBookName2 (This is the output variable of step 3 ) --- Do not pass Full file path name here
Source Sheet, Destination Sheet and Ranges are as per your requirements.
6. Save and Close Instance

Hope this helps..

Sharath

------------------------------
Sharath Kumar Pennada
Consultant
Deloitte Consulting India Private Limited
Asia/Kolkata
------------------------------

RE: I think you also need to open

joakimeklund — Fri, 23 Aug 2019 06:48:00 GMT

Solid solution. Just want to add that I have some mixed experience with the "Show" action in the MS Excel VBO, the workflow should be functional without calling that action. So I don't think the action should be used post development

/Joakim

------------------------------
Joakim Eklund
Senior RPA Developer
Swedbank AB
Europe/Stockholm
------------------------------

RE: I think you also need to open

Sharath_KumarPe — Fri, 23 Aug 2019 08:10:00 GMT

I completely agree with you Joakim.
I'm not a big fan of using Show action after development.
But Blue Prism is suggesting to use 'show' action for this 'copy and paste worksheet as range' action.
This should do no harm in this case.

------------------------------
Sharath Kumar Pennada
Consultant
Deloitte Consulting India Private Limited
Asia/Kolkata
------------------------------

RE: I think you also need to open

raysen16 — Wed, 16 Feb 2022 06:42:00 GMT

How Do we Write the Source Range and Destination range? Can anyone give me example

------------------------------
Kumaresan Ganesan
IT Support Specialist
Association of International Certified Professional Accountants
Asia/Kuala_Lumpur
------------------------------

RE: I think you also need to open

RaviKumar3 — Wed, 16 Feb 2022 08:25:00 GMT

True, Show really helps in copy paste action.

------------------------------
Ravi Kumar
Sr Automation Designer
Ericsson
Asia/Kolkata
------------------------------

RE: I think you also need to open

devneetmohanty07 — Wed, 16 Feb 2022 08:58:00 GMT

Hi @raysen16,

Try giving the source range as "A17:BC:3000" and destination range as "A1" only and see if you are getting the desired outcome.

------------------------------
----------------------------------

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: I think you also need to open

raysen16 — Wed, 16 Feb 2022 09:31:00 GMT

Thank you @devneetmohanty07 it works great and i appreciate your help. I Use "A17:BC3000" perfectly capturing the range

------------------------------
Kumaresan Ganesan
IT Support Specialist
Association of International Certified Professional Accountants
Asia/Kuala_Lumpur
------------------------------

RE: I think you also need to open

devneetmohanty07 — Thu, 17 Feb 2022 06:19:00 GMT

Glad your issue got sorted 🙂

------------------------------
----------------------------------

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------