Retrieve data from a series of worksheets in a directory

Hi,

I have a folder and within this there are 5 other subfolders

What I would like a macro to do is list the excel files within these folders, and then in the columns next to it retrieve the data from cells A3:AV3 on say, Sheet1, of each file.

So it would look like this:

Folder A

File1.xls [data here..........]
File2.xls [data here..........]


Folder B

etc.

I found a couple sites with code to loop through a directory etc but was unable to get it to work,

Can anyone help?

Thanks!

This is based on the macro published here:

Workbooks To Sheets - Part 3


Just edit the main fPATH to your main folder and run it. If any workbook does not have a "sheet1" it will prompt you to select a sheetname from the currently examined workbook.

Please Login or Register  to view this content.