I have to deal with about 100 workbooks which are functionally identical
including the workbook name. Each is stored in a separate folder.

I need to create a consolidated workbook which includes data obtained by
references to certain cells in each of these workbooks.

The following reference works:
='G:\Folder_Name\[Workbook]'!Cell_Reference

I need to be able to supply a different folder name for each workbook but I
cannot construct anything that will work.

As all the workbooks have the same name, I cannot have more than one open at
a time.

Any help would be very much appreciated.
--
John D. Robinson CFP

"John Robinson" wrote...
I have to deal with about 100 workbooks which are functionally identical
including the workbook name. Each is stored in a separate folder.
....
I need to be able to supply a different folder name for each workbook but I
cannot construct anything that will work.
....

See

http://groups-beta.google.com/group/...443753560f0075

(or http://makeashorterlink.com/?F2993260A ).