Read/Write Range of a single sheet in a workbook with multiple sheets

Help Activities
, ,
1

Hey guys,

I am stuck in a fix on read/write range. I have several workbook and want to use read range in the same name sheet in each of them and then write range onto a final workbook (merge all sheets with the same name into an existing workbook).

The code I wrote is working but its writting the same info = number of sheets the workbook has. I’ve tried everything and cannot find a sollution.

Could you guys help? Below is the code I am using:

Insertion on the new data.xaml (14.9 KB)

2

Hi @diogo.grac, I hope you are doing well.
Insertion on the new data.xaml (27.0 KB)

For a workbook with multiple sheets and if sheet name is not sheet1 I have created a different logic you can see in workflow and for multiple sheets in a single workbook it will create different NCB number sheets in output.

Just update the file paths of excel application scope at last and strReports in the beginning, You will get your output,

Thanks & Regards,
Shubham Dutta

3

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