Getting automation error the interface is unknown when navigating IE thru VBA

Hi,

I don't have much experience in VBA programming but I need to automate getting a data from a secured website. However, I would always get an error when navigating to the website that I intend to. It would open IE and the website itself, but the error would pop up and the code would just stop at "Do Until ieApp.ReadyState = READYSTATE_COMPLETE". It would work on google.com, though.

Would someone know what the root cause is?

I'm using Excel 2010 and IE8

Runtime Error:
automation error
the interface is unknown

Please Login or Register  to view this content.

Originally Posted by belle08

Hi,

I don't have much experience in VBA programming but I need to automate getting a data from a secured website. However, I would always get an error when navigating to the website that I intend to. It would open IE and the website itself, but the error would pop up and the code would just stop at "Do Until ieApp.ReadyState = READYSTATE_COMPLETE". It would work on google.com, though.

Would someone know what the root cause is?

I'm using Excel 2010 and IE8

Runtime Error:
automation error
the interface is unknown

Please Login or Register  to view this content.

Here is a quick and easy solution for this issue:

Instead of:

Set ieApp = New InternetExplorer

Use:

Set ieApp = New InternetExplorerMedium

As Simple as that