I would like the user to select a directory and file and then use this
filename so that cells in the spreadsheet link to the selected file.
Basically once the user selects the file he needs the spreadsheet will
update all the cells relative to this chosen file. As the selected file could
be in different directories I don't want to tie the search to a single
directory, but rather let the user choose it.

Is there a simple solution?

Instruct the user to use:
Find/Replace (look in formulas) to update either the directory or the file
name. If Excel gets confused, it may bring up a dialog box, but that's O.K.
--
Gary''s Student - gsnu200765


"Rolohound" wrote:

I would like the user to select a directory and file and then use this
filename so that cells in the spreadsheet link to the selected file.
Basically once the user selects the file he needs the spreadsheet will
update all the cells relative to this chosen file. As the selected file could
be in different directories I don't want to tie the search to a single
directory, but rather let the user choose it.

Is there a simple solution?