Hyperlinks
 

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


--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=378039