Changing MSWord OLE Paths

[ptmuldoon]

I've taken my project to that 'next level', but am still a rookie at this stuff, and could use any and all help in trying to continue learning. Especially since I can't seem to find to much info on working with MSWord with vba.

In Excel, I'm working to create a macro that will open word a document, and then change all of of the OLE links in the file (about 70 of them) to the existing Excel document. I've learned in Word you can press Alt-9 to toggle the view between the OLE. I currently then do a global search and replace on the filepath and name.

And I have worked out how to Open a Word Document and then Save it. But its the middle part on how change the OLE paths.

I hope that makes sense. Below is my test code (mainly from some samples i found on the web and books) to open and save the file

Please Login or Register  to view this content.

[macropod]

See the attachment to: http://windowssecrets.com/forums/sho...External-Files. The code there shows how to go about modifying the .LinkFormat.SourceFullName property for each linked object. Although there is also a .LinkFormat.SourcePath property that should in theory be easier to use, in practice I've found it unreliable.

[ptmuldoon]

Thanks Macropod.

I had read/found that once in the past, but actually could not get it work properly. But anyway, I'm not sure if I'm on the right track or not. I am running the code from Excel, not Word. So unsure if I need to modify to much or not.

I added this to the code above (in the excel macro) after the save command. But not working just yet.

The OldPath will always be the same. So think I can just search the word document for that stuff? But does searching a word document search the linked chart, or is pressing Alt-F9 needed first?

Please Login or Register  to view this content.