1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Sub tesreq()
Dim url$,lig#,col#,tablo,matable,mestr,mestd
url = "http://www.geny.com/partants-pmu/2017-08-25-cabourg-pmu-prix-de-cherbourg_c922077"
With CreateObject("microsoft.xmlhttp"): .Open "post", url, False: .send: code = .responsetext: End With
With CreateObject("htmlfile")
.body.innerhtml = code
Set matable = .getelementbyid("tableau_partants")
Set mestr = matable.getelementsbytagname("TR")
ReDim tablo(mestr.Length, mestr(1).Children.Length)
For lig = 0 To mestr.Length - 1
Set mestd = mestr(lig).getelementsbytagname("TD")
For col = 0 To mestd.Length - 1
tablo(lig, col) = mestd(col).innertext
Next
Next
End With
Cells(1, 1).Resize(mestr.Length, mestr(0).Children.Length).Value = (tablo)
End Sub |
Partager