Hyperlinks in Word cut at #

[Andrzejek]

Getting hyperlinks from Word document, but some of them are pretty long, something like

http://www.abcd.com/zgx-bin/retrieveEC23y1.0.1.7.18&r=PART#23:1.0.1.7.18.0.1.4

and when I say:
oLink.Address, the link is cut at the # character.
What do I need to do to get the whole URL, including # and whatever is after that?

 

[combo]

The rest is in subaddress.

Sub test()
Dim wdDoc As Word.Document
Dim oLink As Word.Hyperlink

Set wdDoc = ThisDocument
Set oLink = wdDoc.Hyperlinks(1)
1 Debug.Print oLink.Address & "#" & oLink.SubAddress
2 Debug.Print oLink.TextToDisplay
3 Debug.Print oLink.Name
End Sub

In (1): I guessed the '#' sign.
In (2): the code displays the text on the screen, to get proper address it has to be displayed.
In (3): '#' is replaced by ' - '.

 

[Andrzejek]

Thanks combo,

I found this code:

If hyperlink.SubAddress <> "" Then
    strUrl = hyperlink.Address & "#" & hyperlink.SubAddress
End If

It's time to test it...