Sw-Ags12
01-02-2018, 09:37 PM
Hi guys,
I'm trying to get my username and pw to populate in the following site. https://bao.arcgis.com/esriBAO/login/index.html
Here is my code: what am I doing wrong?
Option Explicit
Sub BrowseToSite()
Dim IE As New SHDocVw.InternetExplorer
Dim HTMLDoc As MSHTML.HTMLDocument
Dim HTMLInput As MSHTML.IHTMLElement
Dim HTMLButtons As MSHTML.IHTMLElementCollection
IE.Visible = True
IE.Navigate "https://bao.arcgis.com/esriBAO/login/index.html"
Do While IE.ReadyState <> READYSTATE_COMPLETE
Loop
Set HTMLDoc = IE.Document
Set HTMLInput = HTMLDoc.getElementById("username")
HTMLInput.Value = "12345"
End Sub
Side note: can anyone recommend a source for VBA basics?
Thanks, Gig'em, and cheers!
I'm trying to get my username and pw to populate in the following site. https://bao.arcgis.com/esriBAO/login/index.html
Here is my code: what am I doing wrong?
Option Explicit
Sub BrowseToSite()
Dim IE As New SHDocVw.InternetExplorer
Dim HTMLDoc As MSHTML.HTMLDocument
Dim HTMLInput As MSHTML.IHTMLElement
Dim HTMLButtons As MSHTML.IHTMLElementCollection
IE.Visible = True
IE.Navigate "https://bao.arcgis.com/esriBAO/login/index.html"
Do While IE.ReadyState <> READYSTATE_COMPLETE
Loop
Set HTMLDoc = IE.Document
Set HTMLInput = HTMLDoc.getElementById("username")
HTMLInput.Value = "12345"
End Sub
Side note: can anyone recommend a source for VBA basics?
Thanks, Gig'em, and cheers!