Hyperlinks

  • Thread starter Thread starter Ket
  • Start date Start date
K

Ket

Hello,

I am using Excel 2003 with Office XP.

I have an excel workbook that contains a number of hyperlinks to other
workbooks.
My workbook and the other workbooks have been moved onto a different
server and now, obviously, the links do not work.

Is there an easy way to re-establish these links without having to do
each one again manually. There are hundreds of links in my workbook.

Many thanks.

Ket
London
 
hi Ket,

a bit of VBA will do the trick.

Code:
--------------------

For Each h in Worksheets(1).Hyperlinks
Replace( Expression := h.address, _
Find := "old_server_name", _
Replace := "new_server_name" )
Next

--------------------


HTH

Art
 
Back
Top