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.
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.