I'm trying to copy ALL data from a particular worksheet in workbook "A" and simply paste that exact same worksheet's data into a particular worksheet in workbook "B". I've set handle 1 as the "destination" workbook, and handle 2 as the "source" workbook. In the MS Excel VBO "Copy and Paste Worksheet Range" object, I've added the source workbook and source worksheet names, as well as the source range such as "A1:B5", and did the same thing for destination. I'm confused about what to put in the "Handle" row. In the inputs section of the VBO, which handle is the input? The source or the destination or neither?
When I try to run it I get "Failed to copy worksheet: Invalid index. (Exception from HRESULT : 0x8002000B (DISP _E_BADINDEX))
All I want to do is simply copy and paste one worksheet to another. I don't need to manipulate the data so I don't want to bring it into Blue Prism if possible as a collection because it's too slow, if possible.
What am I doing incorrectly? Prior to the copy/paste action, i've created instances for both workbooks, opened the workbooks, and show them.
Thanks!
When I try to run it I get "Failed to copy worksheet: Invalid index. (Exception from HRESULT : 0x8002000B (DISP _E_BADINDEX))
All I want to do is simply copy and paste one worksheet to another. I don't need to manipulate the data so I don't want to bring it into Blue Prism if possible as a collection because it's too slow, if possible.
What am I doing incorrectly? Prior to the copy/paste action, i've created instances for both workbooks, opened the workbooks, and show them.
Thanks!