How to copy a Excel worksheet from one work book to Another WorkBook

[MarinaDutta]

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

[ewilson · Accepted solution]

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

[MarinaDutta]

------------------------------
Marina Dutta
------------------------------

[MarinaDutta]

Dear Eric ,

Thank You for the solution

Thanks &Regards,
Marina

------------------------------
Marina Dutta
------------------------------