RE
Re
bon il faudra peut etre enlever le prefetch navigateur dans la requete
il est utile quand on fait la requete sur la même url x fois régulièrement
donc
Option Explicit
Sub CLEARALL()
Range("F:M").ClearContents
End Sub
Function GetCodeHtmlVpat(UrL)
Dim req As Object
Set req = CreateObject("microsoft.xmlhttp")
req.Open "GET", UrL, False
req.setrequestheader "Accept", "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8"
req.setrequestheader "Accept-Encoding", "gzip , deflate, br"
req.setrequestheader "Accept-Language", "fr,fr-FR;q=0.8,en-US;q=0.5,en;q=0.3"
req.setrequestheader "Connection", "keep-alive"
req.setrequestheader "Host", "velo.ffc.FR"
req.setrequestheader "User -Agent", "Mozilla/5.0 (Win"
'req.setrequestheader "Sec-Fetch-Dest", "document"
'req.setrequestheader "Sec-Fetch-Mode", "navigate"
'req.setrequestheader "Sec-Fetch-site", "none"
'req.setrequestheader "Sec-Fetch-User", "1"
'req.setrequestheader "Upgrade-Insecure-Requests", "1"
req.send
GetCodeHtmlVpat = req.responsetext
End Function
Sub test()
Dim Lig&, UrL$, tabl, trs, i&, c&, tablo, CeL
CLEARALL
For Lig = 1 To Cells(Rows.Count, "A").End(xlUp).Row
UrL = Range("A" & Lig).Value
With CreateObject("htmlfile")
.body.innerHtml = GetCodeHtmlVpat(UrL)
Set tabl = .getelementsbytagname("table")(0)
Set trs = tabl.getelementsbytagname("TR")
ReDim tablo(1 To trs.Length, 1 To trs(0).Children.Length)
For i = 0 To trs.Length - 1
For c = 0 To trs(i).Children.Length - 1
tablo(i + 1, c + 1) = Replace(trs(i).Children(c).innertext, Chr(10), " ")
Next
Next
End With
Set CeL = Cells(Rows.Count, "G").End(xlUp).Offset(2)
CeL.Offset(, -1) = UrL
With CeL.Resize(UBound(tablo), UBound(tablo, 2))
.ClearContents
.Value = tablo
.EntireColumn.AutoFit
ActiveSheet.ListObjects.Add(xlSrcRange, .Cells, , xlYes).Name = "Tableau COURSE_" & Lig
End With
Next
End Sub
resultat