Specifically Opening a Link in Internet Explorer using VBA RRS feed

  • Question

  • I am using the code below to open links that are compiled on a sheet, but I need these links to open specifically in internet explorer even when it is not set as the default browser. If anyone has any ideas it would be greatly appreciated. Thank you.

    ' ZVI:2011-05-30 VBA Macro For Already Open IE Window
    ' Reference required: Tools - References - Microsoft Internet Controls
    Sub GetIE()
      Dim shellWins As ShellWindows
      Dim IE As InternetExplorer

      Set shellWins = New ShellWindows

      If shellWins.Count > 0 Then
        ' Get IE
        Set IE = shellWins.Item(0)
        ' Create IE
        Set IE = New InternetExplorer
        IE.Visible = True
      End If

      IE.Navigate ""

      Set shellWins = Nothing
      Set IE = Nothing

    End Sub

    Thursday, August 27, 2015 3:30 PM

All replies