Windows 7 / Internet Explorer 9 Beta Automation?

zizzerboy

New Member
Joined
Aug 1, 2009
Messages
7
Hello everyone,

I am running Windows 7, Excel 2007. I recently installed Internet Explorer 9 beta (which by the way is BEATIFUL!! Death to all taskbars!!!:devilish:).

But alas, some code of mine that used to work in Windows XP, Internet Explorer 7 simply does not work. Here is some example of some of the code:

Code:
Sub GoogleImages()
Set ie = New InternetExplorer
Dim link As Object
ie.Navigate "[URL]http://google.com[/URL]"
Do While ie.ReadyState <> READYSTATE_COMPLETE
    DoEvents
Loop
...

When stepping through this, the locals window shows:

5117397049_e46ab6e861_b.jpg


:unsure: 'No variables' in Document? That is where I get all my stuff! I tried dimming ie as an object instead, no dice.

Anyone else have this problem? Is there any kind of work around? I couldn't find documentation about this anywhere, not even with Google almighty on my side.

I'm hoping/thinking it's just a matter of the internet explorer. If so, I can just revert back to IE8. Any help is appreciated!
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
UPDATE: I downgraded back to IE8, and everything was working again (well, not perfectly; IE8 seems to catch more 'items' on certain webpages than IE7 does). So it seems the problem is purely IE9, which of course is still in beta testing.

Still, if anyone has a solution using IE9, I would prefer that.
 
Upvote 0

Forum statistics

Threads
1,214,870
Messages
6,122,021
Members
449,060
Latest member
LinusJE

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top