-
Merge / Combine Multiple workbooks
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.
-
Hi Sniper,
Does all the files u require to merge have the same name.
-
No the file names differ but the columns names are all the same
-
HI
Look for combine files in the forum i have posted
Tks
Gary
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules