Use a cell to name a file to be opened.

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?
 
J

Jarek Kujawa

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"
 
D

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
Excel - Wich Function should I use? 1
Merging from an Excel file with graphics 1
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Fill tringle in a cell with color 1
Cell data entering slow! 0
Place picture in Excel cell 0

Top