Combine Multiple Excel Files into One File

[Pirvu Vali]

I have two woorkbooks. one is in my documents (documents/testxlsx) and one in D:\test1.xlsx. I want to combine this files in Desktop/master.xlsm.

[Pirvu Vali]

some help, please?

[Pirvu Vali]

can help me?

[Saqib Qureshi]

I have Created a VBA to automatically do this.

The Macro placed in Master.xlsm Does the following:

Open test.xlsx in Documents/

Copies Data along with headings to Master.xlsm

Open test1.xlsx in D:\

Append data excluding headings to Master.xlsm

Closes other Workbooks

Check:

Master.xlsm

[Pirvu Vali]

why show me this error? sssss.png

[Saqib Qureshi]

It will be best if you give the actual address of your documents folder. I might happen due to different Operating System Versions.

[Pirvu Vali]

for test \\nmtserv\userdata$\vapi this is the path. thank you very much. i solve