Readystate Error

[dgs2001]

Hi all

I have an automation code which works fine with excel and ie7, however when trying with ie8 I get an error.

Set ie = CreateObject("InternetExplorer.Application")
 strURL ="http://www.racingpost.com"   
    
    With ie
        .Visible = True
        .navigate strURL
        Do Until (.ReadyState = 4 And Not .Busy): DoEvents: Loop

'''Rest of code here '''

I get an "Automation Error Interface Unknown" on the

 Do Until(.ReadyState = 4 and not .Busy)

It would seem that "ReadyState" is the problem.

Please help with any Ideas

Thanks Duncan

 

[dgs2001]

OK Update

I have just been playing with Internet Settings and discovered that If I tick "Enable Protected Mode " then harmony is restored.

Happy Days

I hope this helps somebody else one day. and If anybody would care to explain why this makes a difference then that would be good too!!

Duncan

 

[yelabbas]

I hope this helps somebody else one day. and If anybody would care to explain why this makes a difference then that would be good too!!

Thanks a lot Duncan,

I was installing a tool of mine at a customer site, and faced this error, your post helped me quickly fix the error
Thanks a lot Man!

Youssef.