Quote:
Originally Posted by RPM7
FYI: the field code being replaced is a link to an excel spreadsheet.
I wanted to use relative links, but apparently that's not possible  |
If it's a LINK field then, no, those don't support 'relative' implementations. For all other kinds of field, though, check out the relative path field code implementation in:
https://www.msofficeforums.com/word/...nal-files.html
On the same page you'll find an attachment containing a macro that can be used to achieve an effect comparable to using relative paths for LINK fields as well.
Quote:
Originally Posted by RPM7
We duplicate a large bunch of documents for every project at work.
Some generic info has to be replaced in each document as per the project & this is the fastest way I can think of doing it.
|
If that's a once-off exercise for each document, that's probably not the optimum approach. A better approach might be to use a macro in the document template that automatically populates any documents based on that template with the data from the relevant Excel file the first time the file is saved to the appropriate folder (which the macro might enforce as soon as the document is created). After all, if the Excel data should remain static once the document is populated, you probably no longer need the links.