MS Excel Copy issue

[Anonymous]

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

------------------------------

[InJoeKhor]

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
------------------------------