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.
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