Use a cell to name a file to be opened.

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I want to use the contents of a cell as part of an INDEX lookup. The
contents of the cell would indicate the name of the file I want to open. Any
ideas?
 
e.g.

=INDIRECT('C:\Documents and Settings\[&A1&".xls]Bonds'!$H$6")

where A1=Somefile

will retrieve data from file "Somefile.xls" stored in C:\Documents and
Settings\, from cell H6 in worksheet named "Bonds"
 
It's not =index() that has trouble with closed files.

=indirect() has trouble with closed files.



Jarek said:
e.g.

=INDIRECT('C:\Documents and Settings\[&A1&".xls]Bonds'!$H$6")

where A1=Somefile

will retrieve data from file "Somefile.xls" stored in C:\Documents and
Settings\, from cell H6 in worksheet named "Bonds"
Click to expand...
 
Back
Top