How do I maintain relative links between a Word and Excel document?

Word's LINK fields generally require a path, which is always absolute. Sometimes they'll work in a relative fashion if you omit the path, but that approach is not reliable. For a Word macro to give the effect of relative paths, check out the attachment to the solution I've posted at:
http://windowssecrets.com/forums/showthread.php/154379-Word-Fields-and-Relative-Paths-to-External-Files

I have created a Word document that is directly linked to data tables and graphs in an Excel document.  I want to email these to someone externally so that the links are maintained (ie if they keep them in the same folder, the same as I had them, then because they have the same place relative to one another on the new computer as they did on mine the links continue to work.)   Basically I need the links to be relative rather than absolute.  

Any ideas?

Thanks,

Mark

They will have to set up the same folder names that you have so that the links will read correctly.

Alternatively embed the EXCEL Workbook into the WORD document to obviate the need for 2 separate files.