I modified the code you posted to tailor to my needs:
Sub Test_1()
Dim oBrowser As New InternetExplorer
Dim oCollection As IHTMLElementCollection
Dim oDoc As HTMLDocument
'Open browser, load page and set HTML document
With oBrowser
.Visible = True
.Silent = True
.navigate "https://www.scbtonline.com"
Do While .readyState <> 4
Loop
Set oDoc = .document
End With
oDoc.getElementById("selectedoption").Click
End Sub
It pulls open explorer, goes to the website, and stops. I must have the wrong Id. I tried various combinations after looking through the source code for the web site (www.scbtonline.com). It looks like a script is present before the code I am interest in, but I do not know how I need to modify the code to deal with that.
I am trying to get it to pick an option from a drop down list. I assume that first consists of getting the Id of the drop down box, then clicking it and going down to whichever selection I want.
Essentially I want to automatical login to my bank account and pull data for budgeting.
Bookmarks