Hi AVBello,
The translation of the error message shows as "error in the select method of the range class"
- In the 'Destination Range' parameter can you check using just "A1" and check what happens
- Also check if the Destination does not have any merged cells etc
- Do a manual copy paste from A1:V52364 (File 1) to A1:V52364 (File 2)
Do it manually using Ctrl C, Ctrl V without Blue Prism and check if it pastes correctly.
Try the above three options and post back your observations.
Hi Rob,Hi @rickjh123
You shouldn't need handle 2 to complete this operation. You should be able to open both Workbooks under handle 1. Note that the "Create Instance" action outputs the handle for me, rather than me having to assume the number. Here's how I did it:
View attachment 94
View attachment 95
The "invalid index" message seems to appear when you set the full file path/name as the Source/Destination Workbook. In my example, when I used [File1] as the Source and [File2] as the Destination, I got the index error. When I amended these to the actual Workbook name (Tech.xls and Tech2.xls), I no longer received the error.
Hope this helps.
Rob
I doubt it is allowed by BP to do so, although you can try that by using copy paste Worksheet range action.Hello! I need to copy only some columns of .xls1 and paste in another .xls2 but in different order of the columns, that is to say, xls1 copied column A and C and paste it in .xls2 in D and E.
Please, I appreciate your help.
regards
Hi Jory,I do not know if the path I have taken is correct, but please, if no problem indicates it.
It Worked. you can use Get Number Rows action if you are not sure about rows in source sheet.Hi @rickjh123
You shouldn't need handle 2 to complete this operation. You should be able to open both Workbooks under handle 1. Note that the "Create Instance" action outputs the handle for me, rather than me having to assume the number. Here's how I did it:
View attachment 94
View attachment 95
The "invalid index" message seems to appear when you set the full file path/name as the Source/Destination Workbook. In my example, when I used [File1] as the Source and [File2] as the Destination, I got the index error. When I amended these to the actual Workbook name (Tech.xls and Tech2.xls), I no longer received the error.
Hope this helps.
Rob
Hi @rickjh123
You shouldn't need handle 2 to complete this operation. You should be able to open both Workbooks under handle 1. Note that the "Create Instance" action outputs the handle for me, rather than me having to assume the number. Here's how I did it:
View attachment 94
View attachment 95
The "invalid index" message seems to appear when you set the full file path/name as the Source/Destination Workbook. In my example, when I used [File1] as the Source and [File2] as the Destination, I got the index error. When I amended these to the actual Workbook name (Tech.xls and Tech2.xls), I no longer received the error.
Hope this helps.
Rob