excel web vba code example

Example: excel vba open webpage

'VBA routine to open a webpage in your computer system's default web-browser:

Sub OpenWebpage(url$)
    ActiveWorkbook.FollowHyperlink url
End Sub


'To open in Internet Explorer through automation use this:

Sub OpenWebpageInIE(url$)
    With CreateObject("InternetExplorer.Application")
        .Visible = True
        .Navigate url
    End With
End Sub