Hi Alex,

See Sample code from Ron de Bruin at:

http://www.rondebruin.nl/copy3.htm#Loop

See particularly: Sub Loop_Through_Files_in_Range()

See also:

http://www.rondebruin.nl/ado.htm

and

http://www.rondebruin.nl/copy7.htm


---
Regards,
Norman



"Alex" wrote in message
...
Hi,

I'm trying to write a function that retrieves certain information from
different workbooks all with the same structure.
There are typically several hundred workbooks containing the needed
information and they are not necessarily ordered sequentially.
In Column A of the active workbook will be a list of id numbers which are
also the names of the workbooks, that the data needs to be pulled from,
minus
the file extension. I've run out of ideas on how to go about doing this.
Any
suggestions would be greatly appreciated.

Thanks,
Alex