I'm trying to login to my morningstar account and download some of my performance history.
I'm using early binding so I have access to intellisense. What I've written goes to the page, but gives an "Automation error (Error 440)" when I try to get it to put my login info.
I have gone to "tools -> references -> shdocvw.dll" as well as microsoft internet control
I'm using early binding so I have access to intellisense. What I've written goes to the page, but gives an "Automation error (Error 440)" when I try to get it to put my login info.
I have gone to "tools -> references -> shdocvw.dll" as well as microsoft internet control
Code:
Sub Morningstar()
Dim ie As New SHDocVw.InternetExplorer
Set ie = New SHDocVw.InternetExplorer
ie.Visible = True
ie.Navigate ("https://members.morningstar.com/memberservice/login.aspx")
While ie.Busy
DoEvents
Wend
ie.Document.all("email_textbox").Value = "username@service.com"
End Sub