Thanks for the replies guys.
@Macropod, I actually used your post on windowssecrets as a reference. It has been very helpful; however, I don't have any VBA experience, so I'm somewhat stumbling along with this one.
As you say, the relative links work fine for INCLUDEPICTURE, which I'm using for updating our clients logo on each document. Its just the excel links that are causing an issue for me.
@gmayor, I've been playing around with your add-in.
How do I integrate the macro you've referred to?
Essentially, I'd like to be able to batch process all the documents to replace the project reference with a new one.
Code:
LINK Excel.Sheet.12 "\\\\C:\Users\Public\Documents\\Project 1\\Production\\Reference material\\Project Info.xlsx" Data!R2C3 \a \t \* MERGEFORMAT }
LINK Excel.Sheet.12 "\\\\C:\Users\Public\Documents\\Project 2\\Production\\Reference material\\Project Info.xlsx" Data!R2C3 \a \t \* MERGEFORMAT }
Thanks