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.