Hi,
I will have around 400 excel files with different names that I'll need to import into a single file. They will all look like the attached file. How do I import all the data into the same excel sheet without opening any of those 400 excel files. And I would love to import the "next file" to the row below the previous one. Any ideas?
Thanks in advance!
Vasco Castro
Last edited by vascobmcastro; 10-25-2010 at 01:30 PM.
This page should be what you need
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
'WORKBOOKS TO 1 SHEET
I have a macro that may be pretty close to "ready to use" for collecting data from all files in a specific folder.The parts of the code that need to be edited are colored to draw your attention.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thanks for the answers! It is now working beatifully!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks