Hi all,
I am new here but would like to post one problem.
I have developed a application that uses IE for querrying data from our intranet servers(majority code was picked up from this NG and tweeked to my requirement)

I have noticed that the application always opens a new instance of the IE. I tried all the solutions available on this NG but no joy. If IE is open, I would like to use the same for my application. Do I need any referance missing?

Code below gives me runtime error 429 "Activex componant can't create object"

If I comment out the on error resume next statement, code always create new instance of IE even if IE is already running.
Please guide me.
Jagruti


Here is my code :
Sub detect_IE()
Dim mybrowser As Object
On Error Resume Next
Set mybrowser = GetObject(, "InternetExplorer.Application")
If Err.Number = 429 Then
Set mybrowser = CreateObject("Internetexplorer.application")
mybrowser.Visible = True
Err.Clear
End If
With mybrowser
.navigate "http://www.google.com"
End With

On Error GoTo 0

End Sub