Combining 20+ files in excel

[ajreissig]

I have a little over 20 excel documents that I want to combine into one. I am using Excel 2007. They are all set up exactly the same. They all have the same header names. They all have only one sheet in each file, etc. What is the easiest way to combine them? I found a few macros online but neither of them work. I keep getting a 400 VB error for the one. Any help would be much appreciated.
-Amanda

 

[VbaHell]

Amanda

Take a look at this link it might help you

http://msdn.microsoft.com/en-us/library/gg549168.aspx