Windows 7 Internet Explorer 9 Error 800706b5; Interface is unknown

[Captainplanet]

Hi,
I had a macro that opened a website, gave values to various objects(radio buttons,dropdown lists, textboxes etc) and then clicked a submit button.
The macro was working fine on Windows XP pro with Internet Explorer 6. Now I have Windows 7 and Internet Explorer 9 and I get the same error message, no matter what.

run-time error ;2147023179 (800706b5)
Automation error
The interface is unknown

Here's the code I'm using:

Please Login or Register  to view this content.

When debugging the IE object is fine until it navigates to the URL. When I add a watch for the object named IE all it's features have values and the object type is WebBrowser2, then after the line ie.navigate "URL" it loses all it's content. All the features get a value of <Automation error> and the type is just object.
Then when proceeding to the next line and calling on the IE object the error message comes.
I've seen other people having the same problem, and I tried a number of the suggested solutions, like adjusting internet explorer safety measures or approach the task with VBscripting, but the problem persists.
Please help!

[Norie]

Is there an actual URL or are you using the string "URL"?

[Captainplanet]

Actual URL, but I would rather not disclose it here.
Please note, The exact macro was working before. It was successfully accessing the website, choosing the required options and carrying the needed actions out. The issue is probably related to Internet Explorer 9.

[Norie]

Could the website itself have changed?

[Captainplanet]

It didn't. The browser opens up the site fine.
But even if the website would have been changed, the object should still shouldn't lose the webbrowser. In case the website was different it should have a problem finding the same elements on the html document, but that comes at a later stage in the code.
The problem here is that the internet explorer application is lost from the object that contains it the moment any website loads.

[Norie]

I've not heard of any such problems with IE9 and it's pretty hard to recreate the situation without a URL and only a few lines of code.

Have you tried it in an earlier version?

[Captainplanet]

Not on windows 7, only on xp professional with IE 6. It was working with that.
Just for arguments sake, here's an actual code.

Please Login or Register  to view this content.

[Norie]

That code works fine for me up to this line which I think is a typo.

Please Login or Register  to view this content.

To fix that I change the code to this.

Please Login or Register  to view this content.

PS I'm using Windows 7 (64-bit) and IE9.

[Captainplanet]

You're right, there was a typo. I was using getelementbyID, not elementsbyID.
Anyway. I think I figured out smg about this error message. I tried to run the code with a random website at home with my wifi toggle. It worked.
However just an hour ago with the company internet connection it didn't. I think there's some kind of firewall or other setting at work here. If I try to run it at work, the thing crashes immediately after IE.navigate. My company is notoriously strict in controlling internet content. Anyway, that's one step closer to the solution.

[Norie]

That definitely sounds like the firewall or some other restriction is at least part of the problem.

[Vigneshts88]

That definitely sounds like the firewall or some other restriction is at least part of the problem.

Here is a quick and easy solution for this issue:

Instead of:

set IE = createobject("internetexplorer.application")

Use:

Set IE = New InternetExplorerMedium

No need to tweak the IE settings