Hello, I am trying to copy column(s) from one excel file to another using Copy and Paste worksheet range action of MS Excel VBO of blue prism. But i am not having a proper understanding of whats the format or syntax of specifying the cells range. I am getting the following error as seen in the attachment. I have also attached the Action stage configuration also. Please help me with the same.
Thanks.
Hi, it depends what you copy. Writting from collection is ussually very slow to me because I copy a lot of data.
I have no clear answer for you. You can try to copy the whole column Range1 = A:A.
I think the workbooks must be visible as well >> use Show before copy
Make sure you get right number of row. RC1 is strange naming, consider that it means the full cell reference in excel. However you have it formatted as number so I guess you really have a number there. Make sure that it is not a zero.
There should be also a way how to use basic functionalities in BP. Activate Sheet, Select range, Copy, Activate Destination sheet, Select cell, Paste.