Making all hyperlinks relative

[christophercbrewster via OfficeKB.com]

My previous posting concerned finding fields. My main goal is to change all
my hyperlinks to be relative. They are copied from Excel and are absolute,
even when I first make them relative in Excel. Can someone suggest an
approach to this? I haven't been able to access the field value using code so
that I can change it. Maybe the right approach would make my previous
question unnecessary (?). I hope.

--
Christopher Brewster
Lockheed Martin, Eagan MN

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-programming/200911/1

 

[christophercbrewster via OfficeKB.com]

I think I've answered my own question. I used this code:

Public Sub ModifyHyperlink()
For Each hypLink In ActiveDocument.Hyperlinks
strLinkPath = hypLink.Address
MsgBox strLinkPath
Next
End Sub

When this runs, the path shown in the message is relative. So maybe there's
nothing to do. But when I use Ctrl-K on a link, it's absolute. Maybe someone
can explain how this works. Thanks.

--
Christopher Brewster
Lockheed Martin, Eagan MN

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-programming/200911/1

 

[macropod]

Hi christopher,

The presence or absence of a filepath in a Hyperlink field does not of itself make the path relative. To see how to implement
relative paths in Word, check out the solution I've posted at:
http://lounge.windowssecrets.com/index.php?showtopic=670027