Relative link to files (objects)

[rbrady]

Hello,

Does anyone know of a way to link to a file (a Word “object”) but make it so the path to the file is a relative path instead of an absolute path?

I know there is a way to change the base for a hyperlink path, but have not been able to find any information about a similar thing for non-Web paths.

As an example, suppose I have a Word file, Letter.doc, and I want to place a linked Excel range from Numbers.xls into it. I would like to do something like keep both of those files in the same directory, but have the ability to move the pair around to another folder or a whole other system and still have the numbers in the .doc update from the .xls. Can I somehow tell Word to find the range in ./Numbers.xls?

Thank you!


PS
I know there is a similar post about this, but it has to do with Access and VBA, which is more complicated than I intend this to be about.

 

[rbrady]

Well, I searched and searched some more and found this page, which confirms that relative links cannot be made in Word.

The discussion did teach me new about the linked objects though: They are handled as fields in the same way a mail merge uses fields. This means you can use Shift+F9 to view the link information of a selected field or Alt+F9 to view the link information for all fields. From there, the link path can be edited, which might be easier than re-linking the file through the GUI in some cases. I tried to make a relative path, but it did not work