Linking Question

[JVS]

I have several books that are all in the same folder (master templates)
I'd like to link them with out recording the "full path", that way I can
copy the files to "project" folders and use them. But I don't want them
pointing back to the files in the master template folder.
Can I declare some kind of variable %HERE% so that the linked files always
searches the folder where the current file is located?

Thanks for any suggestions.
xjvs

 

[Bernie Deitrick]

xjvs,

Once way to do it that always works is to open the several files from the master folder, then save
each file into the project folder (while all the others are open). Then, after they have all been
re-saved, close the files. Excel will update links as necessary.

HTH,
Bernie
MS Excel MVP