Прежде всего - ссылка не работает. Во-вторых: в зависимости от вывода HTTP-запроса может быть 2 подхода.
Если выводится в виде файла, вы можете использовать приведенный ниже код:
Sub DownloadFile(url As String, filePath As String)
Dim WinHttpReq As Object, attempts As Integer
attempts = 3
On Error GoTo TryAgain
TryAgain:
attempts = attempts - 1
Err.Clear
If attempts > 0 Then
Set WinHttpReq = CreateObject("Microsoft.XMLHTTP")
WinHttpReq.Open "GET", url, False
WinHttpReq.send
If WinHttpReq.Status = 200 Then
Set oStream = CreateObject("ADODB.Stream")
oStream.Open
oStream.Type = 1
oStream.Write WinHttpReq.responseBody
oStream.SaveToFile filePath, 2 ' 1 = no overwrite, 2 = overwrite
oStream.Close
End If
End If
End Sub
Если вывод представляет собой простой текстовый HTML-ответ, вы можете сохранить вывод в файл.
Function GetXMLHTTPResult(url As String)
Dim XMLHTTP As Object, attempts As Integer
attempts = 3
On Error GoTo TryAgain
TryAgain:
attempts = attempts - 1
Err.Clear
If attempts > 0 Then
Set XMLHTTP = CreateObject("MSXML2.serverXMLHTTP")
XMLHTTP.Open "GET", url, False
XMLHTTP.setRequestHeader "Content-Type", "text/xml"
XMLHTTP.setRequestHeader "Cache-Control", "no-cache"
XMLHTTP.setRequestHeader "Pragma", "no-cache"
XMLHTTP.setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 6.1; rv:25.0) Gecko/20100101 Firefox/25.0"
XMLHTTP.send
GetXMLHTTPResult = XMLHTTP.ResponseText
End If
End Function
Sub SaveFile(url)
res = GetXMLHTTPResult(url)
Open "C:\res.txt" For Output As #1
Write #1, res
Close #1
End Sub
person
AnalystCave.com
schedule
31.03.2015