How can I get Word 2003/2007 hyperlink follow to work on an address containing [ or { ?

Charles Kenyon · #31 09-07-2025, 08:50 AM

Quote:

Originally Posted by chrisjj

Thanks, but still it would be useful to know.

Because if it fixes the problem for my specific use of reading such a document, I probably don't care about its other failings e.g. for editing.

Thanks. If I had the result of my test showing 2010 does not suffer the problem, then I would.

Robert has reported that the problem is not there in Word 2019. Microsoft 365 would have the same characteristic.

chrisjj · #32 09-14-2025, 02:25 AM

Quote:

Originally Posted by Charles Kenyon

Robert has reported that the problem is not there in Word 2019.

Indeed, and thanks Robert. But still it would be useful to know if the problem is absent in Word 2010, given that the smaller the upgrade, the fewer the new problems (AFAICS).

chrisjj · #33 09-14-2025, 02:29 AM

Solution found. A macro to adjust the hyperlink address. Attached [REMOVED].

Is seems the fault is not in the follow operation, but in CTRL+K Insert Hyperlink, creating a faulty address. My previous manual attempt to correct this was apparently defeated, seemingly by the obstruction of field address editing I now see mentioned elsewhere.

chrisjj · #34 09-14-2025, 04:41 AM

PS Version that fixes [ and {:

Code:

Option Explicit

Sub FixHyperlinkAddress()
' e.g.
' Was FAIL New PDF Document %5b.pdf
' Is FAIL New PDF Document [.pdf
Debug.Print ("---------")
    Dim hlink As Hyperlink
    For Each hlink In ActiveDocument.Hyperlinks
            Debug.Print ("Was " & hlink.Address)
            hlink.Address = Replace(hlink.Address, "%5b", "[")
            hlink.Address = Replace(hlink.Address, "%7b", "{")
            Debug.Print ("Is " & hlink.Address)
    Next hlink
    Beep
End Sub

and attached. Probably not fit for production.

PS The # case https://www.msofficeforums.com/word/...e-address.html is a different kind of fail and I can see no similar solution.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
After creating hyperlink I have to 'ctrl+click to follow link'	Spider8816	Word	3	10-16-2024 05:04 AM
Hyperlink: open the document only once, quit & reopen PP, hyperlink doesnt work anymore	quanghuynguyenhua	PowerPoint	0	10-10-2015 06:17 PM
Convert Word 2007 macro to work in Word 2003	Kamaflage	Word VBA	1	02-25-2015 11:40 PM
moving follow up flags - outlook 2003	Newmarket2	Outlook	0	01-13-2013 04:46 PM
Hyperlink warning for Powerpoint 2007 with Office 2003	cinci-hal	PowerPoint	0	03-01-2012 10:52 AM