MS Excel Copy issue
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
15-11-19 03:34 PM
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
------------------------------
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-04-20 04:44 PM
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
------------------------------
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