Test if Internet Explorer Object Exists

[ExcelChampion]

Trying to test if an Internet Explorer window is already open. Basically, the macro I have first opend a new instance of IE and then does some stuff and then needs to loop back and use the existing window. However, I just can't seem to get it right. It keeps opening a new instance of IE or it does nothing depending on how I structure the boolean. Doing this a few hundred times is a problem.

FYI, ie is declared as a Public Object

Sub PIDQuery()
    Dim myRow As Variant
    Dim i As Integer
    Dim myID As Object, myPassword As Object, BidTypeCd As Object, PartNumOffr0EDrop As Object, overridelink As Object
    Dim x As String

    myRow = Evaluate("MATCH('Control Form'!B3,'Bid Database'!A:A,0)")

    If Not ie Is Nothing Then GoTo again

    Set ie = CreateObject("InternetExplorer.Application")

again:

    With ie

        .navigate "https://www.dibbs.bsm.dla.mil/RA/Quote/QuoteForm.asp?sn=" & WorksheetFunction.Substitute(Sheets("Bid Database").Range("G" & myRow).Value, "-", "") & "&TypeSrch=cq&selection=solicitation&sort=solicitation&scope=all&value=" & WorksheetFunction.Substitute(Sheets("Control Form").Range("G" & myRow).Value, "-", "")
        Do Until .readyState = 4: DoEvents: Loop
        Do While .Busy: DoEvents: Loop
        DoEvents
     'do some stuff...

     End With

End Macro

 

[timorrill]

Try out the suggestions on this website:

http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23212774.html

 

[Tom Urtis]

Maybe this link is the kind of thing you are after:
http://www.mrexcel.com/forum/showthread.php?t=227669

I miss that "Im a Data Anlyst and have no idea what its all about" tag from your sig line.

 

[ExcelChampion]

Maybe this link is the kind of thing you are after:
http://www.mrexcel.com/forum/showthread.php?t=227669

I miss that "Im a Data Anlyst and have no idea what its all about" tag from your sig line.

Heya, Tom. Yes, I should put that tag back in my sig. Weren't you the one that "corrected" that guy? That guy was something else. Makes you wonder how some ppl get along in this world.

BTW, I did get this working. It was a matter of how the logic was structured.