Bob,

There are two options here. Would you like to require the book to be open
in order to pull the value, or would you like the book to be able to pull the
value while it is closed?

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"bob" wrote:

This is a pretty complex problem I think.

I would like to be able to link to cells in separate files, and have that
file path determined by a text input.

Example.

I am working in a file called "Test". I want to reference cell A1 in a file
called "Inputs" saved on my desktop. Is there a way to look at a text input
in my "Test" file that would find A1 in "Inputs" if the text reads
"C:\Documents and Settings\Desktop\Inputs.xls"