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