View Single Post
 
Old 11-30-2014, 01:43 PM
ptmuldoon ptmuldoon is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Sep 2014
Posts: 93
ptmuldoon is on a distinguished road
Default

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.
Reply With Quote