Open Multiple files into one workbook

[kleptilian]

I have several excel documents that all contain one sheet. i am trying to get them all to open up in one workbook that contains all the sheets. What i am doing right now i opening them all up in excel, then reducing their size and dragging all the sheets into one workbook.

Is there an option for this or maybe some code that could help?

[hoyasaxa215]

This code will consolidate the first worksheet from every file within a specified folder.

Please Login or Register  to view this content.

[kleptilian]

Thanks you so much this worked out great.

[kleptilian]

quick question. when I do this the macros i created to consolidate reports no longer work after adding everything together using your code.
When i drag the sheets into one workbook the macros work fine but not after using your macro to add the sheets. any thoughts?

[hoyasaxa215]

Hmm, did you save the consolidated workbook as macro-enabled?