Combining Multiple individual excel file in One Workbook

[sriniprad08]

Hi Team,

Hope you are well. 

I have 10 individual excel file. I need to combine all of them into one workbook with different tabs.

For e.g 

Individual excel file - A, B, C,D

Output - One workbook - E ( with A, B, C ,D ) as individual sheets.

Please let me know,

thanks,

Sri

[binuacs]

@samson211 can you  make sure your macro action setup like below, make sure the file name showing in the file-value is same as the replace part of the action tool

[samson211]

Currently its showing file name and sheet name.

How can we change it to the way you have shown>

Could you guide @binuacs ? 

[samson211]

@binuacs  changed the setting as you mentioned, still error, attached WF and macro settings

   

[binuacs]

@samson211 what is the error you are getting from the first macro?

[samson211]

Error: Get_Sheets_Macro (2): Record #2: Tool #5: The field schema for the output "Output5" changed between iterations.

[binuacs]

@samson211 change the settings inside the first macro like below

[samson211]

but this code seems to "Replace([FileName], '<List of Sheet Names>', [Sheet Names])" error Unknown variable sheet name.

@binuacs , can we talk on personal chat if its ok.

[binuacs]

@samson211 the above change is to fix the first macro, once the first macro get fixed the sheet error will get resolve

[samson211]

Yes, I did it. Its the same. Error still continue. Will find a way out.

Anyways @binuacs thanks for the support and time.

[binuacs]

@samson211 @ if you are still getting the error means your settings is not correct, can you upload your workflow with some dummy data?