Excel How to update 100's of HTML Links instantly

[Arska]

HI

I have hundreds of HTML links, in my excel workbook pointing to a
certain HTML document, however I need to change the location and update
the links.

Is there anyway in Excel of automatically updating all links to point to
the new location, manually this is a nasty task.

-Arska

 

[Ron de Bruin]

Try this

I copy this from David McRitchie his site
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyp

Sub Fix192Hyperlinks()
Dim OldStr As String, NewStr As String
OldStr = "http://192.168.15.5/"
NewStr = "http://hank.home.on.ca/"
Dim hyp As Hyperlink
For Each hyp In ActiveSheet.Hyperlinks
hyp.Address = Replace(hyp.Address, OldStr, NewStr)
Next hyp
End Sub

If you want to fix the display text you can also include .TextToDisplay

There have been postings to fix hyperlink paths in the excel.links newsgroup. Also see if Dick Kusleika's code and explanation
helps, it is found in http://google.com/groups?threadm=u7jGaPnWCHA.1748@tkmsftngp09