cancel
Showing results for 
Search instead for 
Did you mean: 

MS Excel Copy issue

Anonymous
Not applicable
I have to copy data partially from different excels and paste into another template.
The logic we built to achieve this at times partially copying the data and saving the file but we are expecting it to give a notification incase of partial update.
Could anyone please suggest how to know whether the template has properly updated before saving it.

------------------------------
Padmaja

------------------------------
1 REPLY 1

InJoeKhor
Staff
Staff
Hi Padmaja, 

Have you tried using EXCEL VBO with the action 'Copy and Paste Worksheet Range'?

A high level steps could be like this:
Create Instance, Open Source Workbook and Destination Workbook , Copy and Paste worksheet range Action, Save and Close Instance

Hope this helps.

Thanks,
In Joe

------------------------------
In Joe Khor
Sr. Product Consultant
Blue Prism
------------------------------
In Joe Khor Sr. Product Consultant Blue Prism