VBA error when trying to close IE after accessing intranet site

Question

The code below works fine if a internet site such as google is used. However, I need to access a work intranet site. When I do I get the following error, run-time error '-2147023179 (800706b5)': Automation error The interface is unknown.

Dim ie As Object

Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate "INTRANET SITE"

Do While ie.Busy
    DoEvents
Loop

ie.Quit
Set ie = Nothing

Please help. Thanks.

NOTE: If excel is ran as administrator then this works fine; however, I don't think its possible for excel to be ran as admin for just this one workbook.

possible duplicate of [Excel VBA Controlling IE local intranet](http://stackoverflow.com/questions/12965032/excel-vba-controlling-ie-local-intranet) — ozmike, Feb 26 '15 at 01:10

Steven Marcus · Accepted Answer · 2012-11-21T00:15:16.823

2

Unchecking protected mode fixed the problem.

Also can use the following bit of code

Set ie = New InternetExplorerMedium

edited Nov 21 '12 at 00:15

answered Nov 21 '12 at 00:10

Steven Marcus

393
3
15

I like the second option due to the fact that security isn't affected for when the user normally uses the internet. – Steven Marcus Nov 21 '12 at 00:49

VBA error when trying to close IE after accessing intranet site

1 Answers1

Linked