I get Run-time error '-2147467259 (80004005)': Automation error
Excel VBA Code:
Sub Test4()
Dim url As String
Dim ie As Object
url = "https://www.google.com/?gws_rd=ssl"
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.navigate url
Set ie = nothing
End Sub
Error occurs when executing the CreateObject command.
The following VBA Library References are checked:
Visual Basis for Applications
Microsoft Excel 16.0 Object Library
OLE Automation
Microsoft Office 16.0 Object Library
Running Windows 7, SP1; Office 16.0
How do I avoid getting this error?