PDA

View Full Version : Automating IE7 in Vista with Excel 12



dgacorp
10-19-2006, 11:10 AM
Hi, my problem regards this piece of code:

Dim ie as InternetExplorer
Set ie = new InternetExplorer

ie.visible=false
ie.navigate "some url"

Do While ie.readystate=4
Loop

This code is ok in Windows XP also with Internet Explorer 7 installed and running Office System 2007 (with Excel 12). But in Windows Vista this code gives some errors.
The first point is about the row "ie.visible=false". This instruction is ignored, and IE7 is always visible. The second point is the object ie. I receive Automation error reading it just with the instruction "Do while ie.readystate=4". If I comment it, and use sleep to wait until IE7 has entirely downloaded the page, I get Automation error accessing ie.document.all.

I'm running the last build of Vista (RC2 5744).

Any suggestion?

Thanks.

Ken Puls
10-19-2006, 11:24 PM
Sorry, I can't help as I'm not running a single one of those, but I did want to ping in here to see the response. You're really on the bleeding edge with your platform. :)