Thread: Use a cell to name a file to be opened.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Use a cell to name a file to be opened.
It's not =index() that has trouble with closed files.

=indirect() has trouble with closed files.



Jarek Kujawa wrote:

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"

--

Dave Peterson
Reply With QuoteReply With Quote