FollowHyperLink Vba Anchor Issues

Hello,
I have this simple script to explain the issue I'm running into.

To explain this better I'll use the example

PHP Code: 

Sub test()
Dim URL As String
URL = "https://www.rapidtables.com/web/html/link/html-anchor-link.html#same-page"
ActiveWorkbook.FollowHyperlink Address:=URL

End Sub 


This example loads the URL with https://www.rapidtables.com/web/html...0-%20same-page

Why is the #=%20-%20? Can some assist? Thank you

Thank you, this explain what is happening much better. Now I need to make it work. This is what I have tried

PHP Code: 

Sub test()
Dim URL As String
URL = "https://www.rapidtables.com/web/html/link/html-anchor-link.html%23same-page"
ActiveWorkbook.FollowHyperlink Address:=URL
End Sub 


What is the escape character to make it read as a # sign. Sorry, didn't stay at the holiday inn express last night.

Originally Posted by davesexcel

Do you have to change it? Can you not just keep it as what you had in Post #1?

I have to change it because it does this to the linkAttachment 660320

After you had mentioned that it was strange, I decided to test on another computer in the office. It worked fine...so this is isolated to my computer. The way I made it work was with a shell command and it worked perfectly fine. Thank you for your help.