topic RE: MS Excel Copy issue in Product Forum

MS Excel Copy issue

Anonymous — Fri, 15 Nov 2019 15:34:00 GMT

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

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

RE: MS Excel Copy issue

InJoeKhor — Fri, 24 Apr 2020 15:44:00 GMT

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