Does anyone know of a way to have a user type in a file location into a
named cell and then use that information in other formula?

For instance, assume that a file used once is located at
\\server\allocation\space\myexcelMay06.xls
Next, lets assume the user types that into a cell that is name FILE

I'd like the formula to be able to look into that file at specific cell
references to pull information from that file.

This is somewhat similar to replacing links, but with a different
mechanism.

Thoughts?

By the way, I probably need to stay away from VB as the end user won't
have much support if anything goes wrong.

Check out Laurent Longre's INDIRECT.EXT, part of the morefunc.xll free
add-in, at http://xcell05.free.fr

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
Does anyone know of a way to have a user type in a file location into a
named cell and then use that information in other formula?

For instance, assume that a file used once is located at
\\server\allocation\space\myexcelMay06.xls
Next, lets assume the user types that into a cell that is name FILE

I'd like the formula to be able to look into that file at specific cell
references to pull information from that file.

This is somewhat similar to replacing links, but with a different
mechanism.

Thoughts?

By the way, I probably need to stay away from VB as the end user won't
have much support if anything goes wrong.