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
| Public Function TempsTrajet(sURL As String) As String
Dim xmlHttp As Object, sText As String, k1 As Long, k2 As Long, sTT As String
Set xmlHttp = CreateObject("Microsoft.XMLHTTP")
If xmlHttp Is Nothing Then
MsgBox "Unable to create XMLHTTP object, it's probably not installed on this machine", vbCritical
Exit Function
End If
xmlHttp.Open "GET", sURL, False
xmlHttp.Send
If xmlHttp.ReadyState = 4 Then
If xmlHttp.Status = 200 Then
sText = xmlHttp.responseText
'Debug.Print sText
k1 = InStr(1, sText, "min\", vbBinaryCompare)
If k1 = 0 Then
TempsTrajet = "Non trouvé !?"
Else
k2 = InStrRev(sText, "\", k1 - 1, vbBinaryCompare)
sTT = Mid(sText, k2 + 2, k1 - k2 + 1)
TempsTrajet = sTT
End If
End If
End If
Set xmlHttp = Nothing
End Function |
Partager