Extract data from closed workbooks

[juergenkemeter]

Hi!

I have a folder containing about 300 Excel workbooks. These contain the same Sheet names. ('Sequence Data' and 'Sequence Analysis')

Each Sheet is divided into several sectors, i.e. rows, with different headings.
I enclosed two examples.
I must collect all data, written in these different sectors of the sheets, and write them in a workbook.

My idea is to loop through the Folder, and open each workbook.
Then look into their sheets, export available data written in sectors.

Taking the worksheet 'Sequence Data' as an example:
It contains the data sectors 'Primary Sequences', 'Derived Sequences', and 'Electronic Sequences' as you can see in the enclosed files to this thread.
- The source data in 'Primary Sequences' is written in Range(B6:M9)
- 'Derived Sequences' - Range(B11:M14)
- 'Electronic Sequences' - Range(B16:M20)

Now I want to collect all data written in these sectors, into three new target worksheets.

My problem is to process many workbooks, and write their output into a corresponding target sheet,.

Perhaps there is a way to combine the two code examples, from this Link:
http://www.exceltip.com/st/Read_info...Excel/473.html

The first and the second approach (loop and manual selection of source ranges).


Aem...Merry Christmas By the Way!!

Cheers
Juergen