topic RE: Getting error in copy paste range of excel VBO in Product Forum

Getting error in copy paste range of excel VBO

KumariYadav1 — Fri, 18 Jun 2021 06:12:00 GMT

Hi,
Please help me with the following :
Error :

"Failed to copy worksheet: You can't paste this here because the Copy area and paste area aren't the same size.
Select just one cell in the paste area or an area that's the same size, and try pasting again."
This is the error i am getting in the action copy paste range of Excel Vbo.
But the problem is sometimes its running totally fine and sometimes showing this error.
I have two excel file , The original file in which all the data is present , in this excel i m applying some filter and then copying some column values to another excel.
so here originally i was using 20 rows in the original excel , so in this situation it is working ,
but when i am trying to delete some rows from original excel and then performing all the action ,then its showing the above mentioned error.
Can anyone help me with this.

------------------------------
Kumari Yadav
------------------------------

RE: Getting error in copy paste range of excel VBO

mkumar407 — Fri, 18 Jun 2021 12:36:00 GMT

Hi Kumari,

Solution is there in error message.
Before pasting data Using MS Excel VBO - Paste. Use Go to Cell - "A1" so that active cell is A1 and paste will have option to use full excel to paste unknown set of data copied from first excel.

Thanks.

------------------------------
Manish Kumar
Sony India Software Centre
------------------------------

RE: Getting error in copy paste range of excel VBO

KumariYadav1 — Sun, 20 Jun 2021 15:01:00 GMT

Hi, thanks for your response ,
First thing ,actually I want to paste it to some particular cell,
second is I am using two different excel file so if i will use "Go to cell" so, I am not sure that how it will identify that this command is for which excel because in this Action its only asking for handle and cell reference.
Can you tell me what will be the range value if i want to select a full column from 5th row, like for selecting full column we use A:A, if i am trying A5:A , then this is giving error.
help me in this , thanks

------------------------------
Kumari Yadav
------------------------------

RE: Getting error in copy paste range of excel VBO

EmersonF — Sun, 20 Jun 2021 17:44:00 GMT

@Kumari Yadav, Fine?
Are the two files open in the same excel handle?
If so, use the "Activate Workbook" action to activate the second file.

To select the entire column from the fifth row you must use "A5:A", but for that make sure the file is connected and activated.
Doing this you should have no problem

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55 (081) 98886-9544
If my answer helped you? Mark as useful!
------------------------------

RE: Getting error in copy paste range of excel VBO

KumariYadav1 — Tue, 22 Jun 2021 04:19:00 GMT

Yes Ferreira, I already tried this way but I don't know why sometimes it was running fine and sometimes creating issue, so that's why now for this thing im using write to excel.
so it has been solved now.
Thanks everyone for the response.

------------------------------
Kumari Yadav
------------------------------

RE: Getting error in copy paste range of excel VBO

GiaAnns — Wed, 03 May 2023 04:23:00 GMT

I have got rid of the problem by enabling paste special in file options.

------------------------------
Gia Anns
------------------------------