Hyperlinks - VBA code to change hlk address

[Mark]

I've got a few hundred MS Word docs that contain many hyperlinks to other Word and Excel files. The target files have all moved to a new server and I'd like to create code to go through all the docs and hyperlinks and replace every occurrence of "Dgkfs01" to "Dgkfs05". I've got some For...Next loops going that successfully loops through all the documents and returns the address of all the hyperlinks, but now how to change the address? There is no hyperlink base specified.
Thanks for help in advance.

 

[Suzanne S. Barnhill]

If the hyperlink field codes are displayed, you can use simple Find and
Replace. See http://www.mvps.org/word/FAQs/MacrosVBA/BatchFR.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

I've got a few hundred MS Word docs that contain many hyperlinks to other

Word and Excel files. The target files have all moved to a new server and
I'd like to create code to go through all the docs and hyperlinks and
replace every occurrence of "Dgkfs01" to "Dgkfs05". I've got some For...Next
loops going that successfully loops through all the documents and returns
the address of all the hyperlinks, but now how to change the address? There
is no hyperlink base specified.

 

[Mark]

Hi Suzanne - my thanks for your help. Yes that was the first thing I tried when going down this road. I tried Alt+F9 to display the codes and then a search replace, but it appears not to change the underlying hyperlink address. If I change the field code using this method and then do a right click > Edit Hyperlink then the address remains unchanged.

 

[Mark]

Got it ! I forgot to do a CTRL+A F9. I got there through the mvp/word url on Suzannes signature and searched the MVP site. Days of frustration at an end. Thanks.

Here's the link for anyone else : http://www.mvps.org/word/FAQs/General/ChangePathInHyperlinks.htm