"Andrew" wrote in message
...
If I have a value in an excel sheet cell, which is part of a list, and I
give it a name, (eg, Dim MyCellValueName as String), I can use the
statement;
Workbooks.Open "full path and MyCellValueName.xls"
to open a spreadsheet. I can then go to the next cell in that list, give
it
the same name, and open up another spreadsheet. If I am mistaken here,
please let me know.

I have an object wb2 Dim'd at the start, and then use
Set wb2 = Workbooks.Open(strFPath & strFName)

Ed