Variable File Name

  • Thread starter Thread starter marston.gould
  • Start date Start date
M

marston.gould

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)
 
You must log in or register to reply here.

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

Making part of a formula a variable 1
Best Tool to Repair Corrupted PDF Files 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
copy cell from file with variable name 1
Reference the same cell based on tab name 1
Insert file and tab name from list into formula 1
Variable file reference 2
Retrieving Cell Data From Variable Files 3

Back
Top