Automation error - object invoked has disconnected from its clients

[dOOb]

Hello Excel Forum,

Any idea why does the below code work for some URLs, but doesn't for others?

Please Login or Register  to view this content.

I am able to open any webpage, but for some, i'm getting an error the moment i try to print the 'readystate' property:

Capture.PNG

Does anyone know why this is happenening and how to prevent this?

Thanks,

[Tsjallie]

Does inserting a DoEvents command before the Debug.Print command help?

[AB33]

Since you are using early binding ( New), you have to tick IE as a reference on the tools.

Please Login or Register  to view this content.

[AB33]

OR
Late binding

Please Login or Register  to view this content.

[Tsjallie]

Not quite sure, but wouldn't one DoEvents be enough?
Also if the ReadyState would for some reason never get to be 4, the procedure would end up in an endless loop.
So you would need something to bail out of it. Some counter or time-out.

[dOOb]

Thank you, so I tried all of the above suggestions, but nothing worked

'Microsoft Internet Controls' is selected in my references, i think this is what you mean, right? Or should there actually be an 'IE' or 'Internet Explorer' reference?

What puzzles me is that i am able to navigate to any website with this code, but only for some the connection to the ie object get's 'dropped'.

I have tried this now on three machines with the same result.

Also, though not sure how relevant this is, the error messages i'm getting vary between these three:
Capture1.PNG Capture2.PNG Capture3.PNG

[AB33]

The most likely reason could be your version of IE. I did not get an error. Please attach an excel sample, not a picture.

This works for me

Please Login or Register  to view this content.

[dOOb]

Yup, that works for me too for this URL, but my initial code also workes for this URL.

OK, I actually found a solution!!!

I realized that i'm getting these errors only for some internal corporate sites (intranet).

So i searched online and found a solution here http://stackoverflow.com/questions/1...local-intranet

Thank you @AB33 and @Tsjallie for taking time to look into my problem.

Best regards,