This Excel VBA tutorial explains how to use VBA FollowHyperlink Method to open website.
VBA FollowHyperlink Method
FollowHyperlink is used to tell Excel to open up a browser and go to a specific website, or download a file in specific folder, depending on your "Hyperlink" address.
In Excel spreadsheet, there is a similar worksheet function called Hyperlink, but it converts a text to hyperlink but FollowHyperlink function actually "go to" hyperlink.
Syntax of FollowHyperlink Method
expre...
Read More
followhyperlink
Excel VBA run hyperlink
Solution to trigger hyperlink
Use FollowHyperlink function to go to a website.
Public Sub hyper()
ThisWorkbook.FollowHyperlink Range("C6").Value
End Sub
For details of the FollowHyperlink, check out the below article
Excel VBA function FollowHyperlink
Read More