Linking Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JVS - 01 Sep 2006 03:00 GMT

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

Reply to this Message

Bernie Deitrick - 01 Sep 2006 18:58 GMT

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

>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
[quoted text clipped - 5 lines]
> Thanks for any suggestions.
> xjvs

Reply to this Message