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
| Sub test2()
url = "https://pro.zeturf.com/externe/zefiche_cheval_.php?hippodrome=VINCENNES&dr=20160122&nr=4&nc=1&nch=1&"
With CreateObject("htmlfile")
If .parentWindow.clipboardData.setData("Text", recupe_html(url)) Then
Application.ScreenUpdating = False
With Sheets(1)
.Activate
.Cells(1, 1).Select
.Paste
End With
.parentWindow.clipboardData.clearData "Text"
End If
End With
End Sub
Public Function recupe_html(url)
Dim REQ
Set REQ = CreateObject("microsoft.xmlhttp")
REQ.Open "POST", url, False
'headzer de la requete !!!!!!!!!!!!!!!!!!!
REQ.SetRequestHeader "Accept", " text/html, application/xhtml+xml, */*"
REQ.SetRequestHeader "Referer", "http://www.zeturf.fr/fr/accueil/"
REQ.SetRequestHeader "Accept-Language", "fr-FR"
REQ.SetRequestHeader "User-Agent", "Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; WOW64; Trident/6.0)"
REQ.SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
REQ.SetRequestHeader "Accept-Encoding", "gzip, deflate"
REQ.SetRequestHeader "Host", "www.zeturf.fr"
REQ.SetRequestHeader "DNT", "1"
REQ.SetRequestHeader "Connection", "Keep - Alive"
REQ.SetRequestHeader "Cache-Control", "no-cache"
'fin du header de la requete !!!!!!!!!!!!!!!
REQ.send
recupe_html = REQ.responseText
End Function |
Partager