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

Private Sub CommandButton1_Click()
    
   Dim ieApp As InternetExplorer
   Dim UrlHome As String

   UrlHome = Trim(Range("A1").Value) 
   
   Set ieApp = New InternetExplorer
   ieApp.Visible = True

   ieApp.Navigate UrlHome
     Do Until ieApp.ReadyState = READYSTATE_COMPLETE
     Loop

End Sub