Merge some sheet to new file excel (VBA)

Help Activities
, ,
1

I want to merge some sheet to new file excel (VBA)
input.xlsx (64.4 KB)
output.xlsx (12.7 KB)

Example from file input —> I want to copy file to new file and merge sheet (except Paid_AR, Paid_CC , Detail , Special)
*same format

Please guide me about it.

2

@fairymemay

Read the specific sheet you required using Read Range activity

And use Write Range activity and give the newly created sheet path, and pass the Datatable you have created in Read Range

So this will write the contents to the newly created and will create the sheet even if it is not present in the new file

Hope this will help you

Thanks

3

@Srini84 I want use solution by Macro.

4

Hi @fairymemay ,

Please note that UiPath is more of no code platform having inbuilt activities to perform our automations.

we can use invoke code and write our own VB or macro code if we have any complex automations related to excel.

i feel this is very simple requirement not sure why do you require VB Code for this requirement. You could implement by using simple work flow in UiPath.

  1. Using Get work sheets activity to get the sheets and use if condition to control which sheets we have to work on.

  2. Use for each loop to loop the sheet names and use Append range and write range to merge the data into summary sheet.

I have created sample work flow attached. please refer and let us know. thanks.

ExcelAppendDemo.zip (66.2 KB)

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.