Here is the full VBA. I keep recieving object required. Forgive me as I am new to VBA with HTML so I am learning the syntaxt of HTML. I assume, I am not hitting the HTML doc correctly. Tag vs ID?
Sub Macro2()
Dim shellWins As ShellWindows
Dim IE As InternetExplorer
Dim sIEURL As String
Dim ACCURL As String
Dim ROWNUM As String
Set shellWins = New ShellWindows
Set IE = shellWins.Item(0)
ROWNUM = 2
Do While Cells(ROWNUM, 1).Value <> ""
ACCURL = "WEB ADDRESS" & Range("A" & ROWNUM).Value & "#tab9"
sIEURL = IE.LocationURL
IE.Navigate ACCURL
'wait until the page loads
Do While IE.Busy Or IE.ReadyState <> READYSTATE_COMPLETE
DoEvents
Loop
IE.Document.getElementById("investmentCharlesCode")(0).getElementsByClassName("Value")(1).Text
ROWNUM = ROWNUM + 1
Loop
Set shellWins = Nothing
Set IE = Nothing
MsgBox "Completed Account List"
End Sub
Bookmarks