PDA

View Full Version : Merge / Combine Multiple workbooks



reconsniper
08-19-2008, 02:59 PM
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
08-19-2008, 07:41 PM
Hi Sniper,
Does all the files u require to merge have the same name.

reconsniper
08-21-2008, 06:48 PM
No the file names differ but the columns names are all the same

aaupg2323g
08-21-2008, 07:44 PM
HI

Look for combine files in the forum i have posted

Tks
Gary