Hi all,
Sorry to repost but my earlier post posted thru
excelforums did not appeared on this news group.

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