Extracting data from multiple workbook in folder into main workbook

**Julesdude** · 10-14-2010, 10:25 AM

Hi there,

Can anyone help, i need to do the following:

1. Have VBA code that gets Excel to check in a particular folder that is full of forms in .xls format (say about 70 forms)
2. Extract data from each form in the folder (can this be done without opening the form entirely?). Transfer values by row into the already open destination workbook.

The transfer of data from each form is not so much a problem for me code wise. What I really need help with is getting Excel to search in the folder of forms, creating a cycle to go through them one by one. Can a reference to each file in the folder be done by a numeric index i.e. 1, 2, 3 etc?

Help gratefully received.

Am using Excel 2007

**blane245** · 10-14-2010, 10:59 AM

See this thread for starters.

**Julesdude** · 10-14-2010, 11:14 AM

That'll surely help me. Cheers

**JBeaucaire** · 10-14-2010, 11:25 AM

The base code from that thread comes from here:

Workbooks to 1 Sheet

The macro 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.