Combine 50 excel file into one new file

Hi All,

I have 50 Excel file in One folder. Every file has same column such A-E but rows are different. Some have 1000 rows data & another may more or less rows.
I want combine all files data into one file in same folder.


Thanks in advance

Here's one I use. Hope it will be useful too you as well.

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Here's one I use. Hope it will be useful too you as well.

Please Login or Register  to view this content.

Hi JOHN H. DAVIS,
Thanks for your code. Its great. I am learning VBA.
Is there any way complete this task without opening excel files myself?

Try:

Please Login or Register  to view this content.