1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| Option Explicit
Dim lapage
Dim liste As String
Public Function HtmlToText(sHtml)
On Error Resume Next
With CreateObject("htmlfile")
.Write sHtml
HtmlToText = .body.innerText
End With
End Function
Public Function GetXml(sURL)
Dim Xml
Set Xml = CreateObject("Microsoft.XMLHTTP")
Xml.Open "GET", sURL
Xml.Send
Do
DoEvents
Loop While Xml.ReadyState <> 4
GetXml = Xml.ResponseText
End Function
Sub essaie1()
lapage = GetXml("C:\Users\Patrick\Desktop\dumenthtml.html")
liste = liste & "code_niss = " & Split(Split(Split(lapage, "<th>NISS </th>")(1), ">")(2), "<")(0) & vbCrLf
liste = liste & "date_de_naissance = " & Split(Split(Split(lapage, ":birthDate")(1), ">")(1), "<")(0) & vbCrLf
liste = liste & "sexe = " & Split(Split(Split(lapage, "sex")(2), ">")(1), "<")(0) & vbCrLf
liste = liste & "civilité = " & Split(Split(Split(lapage, "Titre")(1), ">")(3), "<")(0) & vbCrLf
liste = liste & "nom = " & Split(Split(Split(lapage, "<span class=""dataLabel"">Nom</span>")(1), ">")(2), "<")(0) & vbCrLf
liste = liste & "prenom = " & Split(Split(Split(lapage, ":firstName")(1), ">")(1), "<")(0) & vbCrLf
liste = liste & "nationalité = " & HtmlToText(Split(Split(Split(lapage, ":nationality")(1), ">")(1), "<")(0)) & vbCrLf
liste = liste & "language_utilisé = " & Replace(Split(Split(Split(lapage, ":language")(1), ">")(1), "<")(0), "?", "c") & vbCrLf
liste = liste & "etat_civil = " & Replace(Split(Split(Split(lapage, ":civilState")(1), ">")(1), "<")(0), "?", "é")
MsgBox liste
End Sub |
Partager