Merge / Combine Multiple workbooks

[reconsniper]

Hello!

I am trying to see if the following scenario is possible. I am trying to take numerous workbooks and combined them into one. They all have the same columns. I located a script that combined all the .xls files that in the same folder. I'm trying to get it to pull from locations for example "C:\tacos", "c:\ham"; "c:\egg"; and "C:\toast". The code I have been experimenting with is located here. vbaexpress.com/kb/getarticle.php?kb_id=773

Thanks for any help.

[parttime_guy]

Hi Sniper,
Does all the files u require to merge have the same name.

[reconsniper]

No the file names differ but the columns names are all the same

[aaupg2323g]

HI

Look for combine files in the forum i have posted

Tks
Gary