VBA run-time error '91' while automating IE7

[tomsoyer]

Hi,

While testing IE7 automation via VBA, I encountered this strange problem. I tried to navigate and parse HTML more than once in IE7 using a for loop (see code below). The code works only for the first loop; after that VBA gives this error message: "run-time error '91' "object variable or with block variable not set"". Does anyone know why it is not possible to execute the same block of VBA code (in my example below) more than once when working with IE7? Thanks.

Sub testIE7()
Dim objIE As InternetExplorer
Dim i, counter As Long
Set objIE = New InternetExplorer

For i = 1 To 2
counter = counter + 1
objIE.Visible = 0
objIE.Navigate2 "http://www.google.com/"
While objIE.Busy: Wend
While objIE.readyState <> 4: Wend

Debug.Print (objIE.document.getElementById("gbar").innerHTML & vbCrLf & "counter: " & counter)

Next i
End Sub

 

[westconn1]

do you need to reset counter to 0 for the next i?

 

[tomsoyer]

No, the counter is only there to keep track of number of loops executed.

 

[westconn1]

i don't see any reason for your error, it tested your code, worked ok with my internet explorer,though i think it is ver 6

 

[tomsoyer]

The code works for IE6, but not IE7. I am testing vba automation on IE7. I don't know if this is a bug in IE7, or an undocumented change. Very strange.