As indicated in his post, Graham's macro assumed the use of hyperlinks, not LINK fields.



When you create a new project, for which the path appears to be based on
C:\Users\Public\Documents\Project 1\Production\Reference material\
with 'Project 1' being variable:
1. In which folder are the new Word files located?
2. Are all the Word files based on the same template?
3. Are the links meant to disappear once they've been updated to point to the correct folder and the current data have been captured (i.e. should their content ever change)?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks macropod

1. The word documents are located in the folder "Production", whilst the spreadsheet is in "Reference material".
2. Yes, the word files are based on the same template.
3. It would be ideal if the links could remain, in case some information in the spreadsheet were to change.