Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do long hyperlinks get truncated on save in Excel? | Excel Worksheet Functions | |||
Addressing hyperlinks in excel | Excel Discussion (Misc queries) | |||
Changing Hyperlinks? | Excel Discussion (Misc queries) | |||
Can 2 different hyperlinks be in the same Excel cell? | Excel Worksheet Functions | |||
up-date hyperlinks in Excel | Excel Worksheet Functions |