Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-02-22 02:39 PM
Dear Team,
Can any one help me in how to copy an Excel Worksheet from one workbook to another workbook using Excel Extended VBO . After creating the VBO in object studio ,I want to use the VBO in Process studio to copy the Worksheet from one WorkBook to another WorkBook.
Thanks and Regards,
Marina
------------------------------
Marina Dutta
------------------------------
Can any one help me in how to copy an Excel Worksheet from one workbook to another workbook using Excel Extended VBO . After creating the VBO in object studio ,I want to use the VBO in Process studio to copy the Worksheet from one WorkBook to another WorkBook.
Thanks and Regards,
Marina
------------------------------
Marina Dutta
------------------------------
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-02-22 05:47 PM
@Marina Dutta,
There are a couple ways you could do this. Take a look at the action Copy and Paste Worksheet Range. You tell it the source workbook, worksheet, and range in addition to the destination workbook, worksheet, and range. It will copy the range within the source worksheet into the range in the destination worksheet.
Another option is to simply get the entire source worksheet as a Collection using the action Get Worksheet as Collection. Then you can use Write Collection to write the contents of the collection into a new worksheet in the destination workbook.
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
There are a couple ways you could do this. Take a look at the action Copy and Paste Worksheet Range. You tell it the source workbook, worksheet, and range in addition to the destination workbook, worksheet, and range. It will copy the range within the source worksheet into the range in the destination worksheet.
Another option is to simply get the entire source worksheet as a Collection using the action Get Worksheet as Collection. Then you can use Write Collection to write the contents of the collection into a new worksheet in the destination workbook.
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-02-22 05:47 PM
@Marina Dutta,
There are a couple ways you could do this. Take a look at the action Copy and Paste Worksheet Range. You tell it the source workbook, worksheet, and range in addition to the destination workbook, worksheet, and range. It will copy the range within the source worksheet into the range in the destination worksheet.
Another option is to simply get the entire source worksheet as a Collection using the action Get Worksheet as Collection. Then you can use Write Collection to write the contents of the collection into a new worksheet in the destination workbook.
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
There are a couple ways you could do this. Take a look at the action Copy and Paste Worksheet Range. You tell it the source workbook, worksheet, and range in addition to the destination workbook, worksheet, and range. It will copy the range within the source worksheet into the range in the destination worksheet.
Another option is to simply get the entire source worksheet as a Collection using the action Get Worksheet as Collection. Then you can use Write Collection to write the contents of the collection into a new worksheet in the destination workbook.
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-02-22 05:38 AM
------------------------------
Marina Dutta
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-02-22 08:00 AM
Dear Eric ,
Thank You for the solution
Thanks &Regards,
Marina
------------------------------
Marina Dutta
------------------------------
Thank You for the solution
Thanks &Regards,
Marina
------------------------------
Marina Dutta
------------------------------
