Hyperlinks

[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

 

[HiArt]

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