I am trying to get the text for the Two Factor line at this web site: https://secure-oecu.org/Common/SignOn/Start.asp
I am using the VBA code below. If you have any ideas, please let me know. I've tried some methods from the MSDN web site but I am missing something. http://tinyurl.com/1tri
Of course once I get this information, I hope to submit the form with the completed information.
Code
Sub IEdata(webSite As String)
Dim IE As Object, z As Object
Dim oTable As Object, i As Integer, j As Integer
Set IE = GetHTMLDocument(webSite)
With IE 'IE.Document
For Each z In .all
Debug.Print "z.ID=" & z.ID
Debug.Print "z.tagName=" & z.tagName
Debug.Print "z.innerText=" & z.innerText
If z.ID = "Table3" Then Set oTable = z
Next z
'Debug.Print "oTable.Rows.Length=" & oTable.Rows.Length '=1
For i = 0 To oTable.Rows.Length - 1
For j = 0 To oTable.Rows(i).Cells.Length - 1
Debug.Print "row" & i & " cell" & j & "=" & oTable.Rows(i).Cells(j).innerText
Next j
Next i
End With