Does anyone know if its possible to create a macro to find and replace a portion of field code across multiple documents?



The fastest way I can do it is:

1. Press (Alt+F9)
2. Press (Ctrl+H)
3. Insert old text in the 'Find' field
4. Insert New text in the 'Replace' field
5. Press (Alt+F9)
6. Repeat process for remaining documents

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

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.