Append multiple excel files' data in a single file

[SD9126]

Hi everyone, I need one help. I have multiple excel data files in a folder. In each file there are 2 sheets: Sheet1 and Sheet2. I want to append all Sheet2 data in a new excel file and also in the output file I need 1 extra column which shows the source file's name. I tried to do this using Wildcard (*) in Input tool but it returned an error saying files' schema are different and ended up pulling only the 1st file's data from the folder. Also tried using Batch Macro but I guess there's some error I'm doing. Please let me know if there is any solution. Thanks in advance.

[atcodedog05 · Accepted solution]

Hi @SD9126 

Try this set the path here

Hope this helps : )

[binuacs · Accepted solution]

@SD9126 also make sure in your macro the below option is updated (View-Interface Designer) in the properties

[SD9126]

Thanks a lot. It worked. Still couldn't understand what went wrong in my step for batch macro. But anyways, thank you :)

[atcodedog05 · Accepted solution]

Happy to help : ) @SD9126 

If our response helps please don't forget to mark it as solution.

Cheers and have a nice day!