updating linked tables in some word doc by using VBA in Excel

Topic

New Reply

Hello all,
I would like to use an Excel sheet to run a macro that will update the paths of all linked tables of all the word documents in a given folder.
I have seen how to check what the code is of a linked table, but how do I change the path in this code and update the word doc?

Thanks for your replies.

Patrick Schouten
The Netherlands

Reply | Quote

Replies

Hi siflaar,

To do this from Excel, you have to start Word (if it’s not already running), then open each document. From there, it’s a matter of using code like that attached to http://lounge.windowssecrets.com/index.php?showtopic=670027 to update the link paths. That code shows how you can change the link paths in the links.

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote

Hello Paul,

Even after searching and reading al lot of posts, I did not find this one.
So thanks for pointing me to it. It seems in de code is enough information for me to create my own code.

greetings,
Patrick Schouten
The Netherlands

PS, how do I mark this thead as [solved]?

Reply | Quote

Hello all! The link that Paul posted no longer works. I need to do a very similar thing – updating the paths of all linked tables in a Word document. I was unsuccessful in searching around the Lounge for the thread. Would Paul, Patrick, or someone else be able to point me to the post? A full post detailing my problem is here. Thanks!

Reply | Quote

The thread referred to in that post is now at: http://windowssecrets.com/forums/showthread//154379-Word-Fields-and-Relative-Paths-to-External-Files

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote