excel vba open code example

Example 1: how to open vba in excel

'To open the VBA Editor in Excel, the keyboard shortcut is:

Alt-F11

Example 2: 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

Tags:

Vb Example

Related