Til dem der selv ønsker at hente afstandende så er der her et script til MS Excel som henter afstandende (Kræver ASPHTTP objectet)
Function test()
Set HTTPObj = CreateObject("AspHTTP.Conn")
strSheet = "Sheet2"
sh = 2
U = 2
T = 1
Do Until Worksheets("Sheet1").Cells(T, 1).Value = ""
N = T
Do Until Worksheets("Sheet1").Cells(N, 1).Value = ""
Sejle = False
HTTPObj.Url = "
http://www.trafikken.dk/vejafstande.asp?action=LISTE&page=dept&objno=1000005487" HTTPObj.RequestMethod = "POST"
HTTPObj.PostData = "By1=" & Worksheets("Sheet1").Cells(T, 1).Value & "&By2=" & Worksheets("Sheet1").Cells(N, 1).Value & "&BMetode=h&SB=Beregn%20afstand"
strResult = HTTPObj.GetURL
tmpval = -1
StartStr = "Afstanden er: "
SlutStr = " km"
Start = InStrRev(strResult, StartStr)
tmpstr = Mid(strResult, Start + Len(StartStr))
Do Until InStrRev(tmpstr, SlutStr) = 0
Slut = InStrRev(tmpstr, SlutStr)
tmpstr = Left(tmpstr, Slut - 1)
Loop
StartStr = "sejlet længde er: "
SlutStr = " km"
If Len(tmpstr) <> 0 And Start <> 0 Then tmpval = CInt(tmpstr)
Start = InStrRev(strResult, StartStr)
tmpstr = Mid(strResult, Start + Len(StartStr))
Do Until InStrRev(tmpstr, SlutStr) = 0
Slut = InStrRev(tmpstr, SlutStr)
tmpstr = Left(tmpstr, Slut - 1)
Loop
If Len(tmpstr) <> 0 And Start <> 0 Then
tmpval = tmpval + CInt(tmpstr)
Sejle = True
Worksheets(strSheet).Cells(U, 4).Value = "Sejle"
End If
Worksheets(strSheet).Cells(U, 1).Value = Worksheets("Sheet1").Cells(T, 1).Value
Worksheets(strSheet).Cells(U, 2).Value = Worksheets("Sheet1").Cells(N, 1).Value
If tmpval <> -1 Then
Worksheets(strSheet).Cells(U, 3).Value = tmpval
U = U + 1
Else
Worksheets(strSheet).Cells(U, 3).Value = "N/A"
End If
If U = 50000 Then
U = 0
sh = sh + 1
strSheet = "Sheet" & sh
End If
N = N + 1
Loop
T = T + 1
Loop
End Function