Hi guys !
I am trying to tranfer a single value from a Website to my Sheet in Excel.
Thanks to Google I have found how to open a link and write my user-id and password, this is the VBA:
It works, it opens the website and writes my user id and pwd in the correct position.
But now, I don't know how to continue... I need to click on the "Sign In" button to proceed.
I have tryed inspecting the website but I don't understand how can I do.
I am trying to tranfer a single value from a Website to my Sheet in Excel.
Thanks to Google I have found how to open a link and write my user-id and password, this is the VBA:
VBA Code:
Sub Login()
Dim IE As SHDocVw.InternetExplorer
Dim iDoc As MSHTML.HTMLDocument
Set IE = New InternetExplorer
With IE
.Visible = True
.navigate ("https://investing.com/portfolio/")
Do While .readyState <> READYSTATE_COMPLETE: DoEvents: Loop
End With
Set iDoc = IE.document
iDoc.all.loginFormUser_email.Value = "my_email"
iDoc.all.loginForm_password.Value = "my_password"
Do While IE.readyState <> READYSTATE_COMPLETE: DoEvents: Loop
Set IE = Nothing
Set iDoc = Nothing
End Sub
It works, it opens the website and writes my user id and pwd in the correct position.
But now, I don't know how to continue... I need to click on the "Sign In" button to proceed.
I have tryed inspecting the website but I don't understand how can I do.