Open 5 workbooks to make a report

[kasharis]

HEllo!
I am today here to get some friendly information ...
if you know code then would be great if i could get it
From start .. i want to load 5 excel files from directory of folder .. okay we guess it will be (c:\folder)
and after that when i get those 5 files loaded to excel ... i would need to make a report from them ... in each file there is 12 sheets of information ...
and then i could slowly make up a code for
I think the code could start something like this

Please Login or Register  to view this content.

If code is inncorect please let me know and provide please with workking code ... !
would be happy!

[JBeaucaire]

If I was going to make a report from 60 worksheets (12 sheets in 5 workbooks) or more, I'd first consolidate all the data into a single worksheet so all standard builtin functions and features could be applied against that single database.

'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.

Workbooks to 1 Sheet

Further down on that page is a "option" showing you how to add in code to cycle through multiple sheets in each opened workbook, you'll need to add that in at the correct spot.