magushi,
Fuçando por aí, cheguei no seguinte código, que abre uma nova aba na instância já aberta do Internet Explorer:
Código: Selecionar todos
Public Sub GetCurrentIEInstanceAndOpenANewTab()
Dim objWindow As Object
Dim objIEApp As Object
Dim objShell As Object
Dim objItem As Object
On Error GoTo Fin
Set objShell = CreateObject("Shell.Application")
Set objWindow = objShell.Windows()
For Each objItem In objWindow
If LCase(objItem.FullName) Like "*iexplore*" Then
Set objIEApp = objItem
End If
Next objItem
If objIEApp Is Nothing Then
Set objIEApp = CreateObject("InternetExplorer.Application")
objIEApp.Visible = True
End If
With objIEApp
.Visible = True
.Navigate2 "http://www.google.com", 2048
While Not .ReadyState = 4
DoEvents
Wend
.Document.all.q.Value = "Excel VBA"
.Document.Forms(0).submit
End With
Fin:
If Err.Number <> 0 Then MsgBox "Error: " & _
Err.Number & " " & Err.Description
Set objWindow = Nothing
Set objShell = Nothing
End Sub
Veja se ajuda.