Mike,

Not sure I understand what you are doing. But if you are trying to copy
information from a list of workbooks to a master workbook - my approach is
to have a list of the workbooks in my master workbook and use a For... Next
loop to open each workbook and copy ranges to the master. Careful coding
can make this run relatively fast.

Others use a technique to search for the files and open each in turn.

Much depends on how the files are named and where they are located.

One of my workbooks pulls files from different folders and copies data to
the master. Again using a list in the master.

steve

"Mike" wrote in message
...

I have a template workbook that uses 20 named ranges to
get picked up my a master workbook. Complexity is that
there are 100+ project workbooks to be compiled. All are
based on same template but require different filenames
(corresponding to project names. The cell addresses and
named ranges are the same in every template workbook.

What is a good approach for this (other than Access)?

TIA

Mike