Thanks Macropod
And please forgive me as I am still learning.
I'm working to modify the relevant path macro code to work based off the user picking an existing file. Keep getting stuck in I think an infinite loop that I need to work out!!
But I'm still struggling with how you can separate out the File Path and File name Separately. I believe I need to do this for Graphs that are OLE linked to word. The LINK code for those looks something like the below:
Note: This is with Office 2007. I'll fix it all to Office 2013 in a month when our Company upgrades.
Code:
{ LINK Excel.Sheet.8 "C:\\Data\\_Template\\Template Workpapers.xltm" "Receivable Charts![Template Workpapers.xltm]Receivable Charts Chart 4" \p }
Notice that the file name is shown twice? Both as part of the initial file path (SourceFullName) and then a second time as part of the chart information?
So I think for those graphs, I need to replace the filename separately. Currently I do a global search and replace on the file path and file name separately.