How do I download a file using VBA (without Internet Explorer)

by

This solution is based from this website:
http://social.msdn.microsoft.com/Forums/en-US/bd0ee306-7bb5-4ce4-8341-edd9475f84ad/excel-2007-use-vba-to-download-save-csv-from-url

It is slightly modified to overwrite existing file and to pass along login credentials.

Sub DownloadFile()

Dim myURL As String
myURL = "https://YourWebSite.com/?your_query_parameters"

Dim WinHttpReq As Object
Set WinHttpReq = CreateObject("Microsoft.XMLHTTP")
WinHttpReq.Open "GET", myURL, False, "username", "password"
WinHttpReq.send

If WinHttpReq.Status = 200 Then
    Set oStream = CreateObject("ADODB.Stream")
    oStream.Open
    oStream.Type = 1
    oStream.Write WinHttpReq.responseBody
    oStream.SaveToFile "C:\file.csv", 2 ' 1 = no overwrite, 2 = overwrite
    oStream.Close
End If

End Sub

More Related Contents:

  1. Yahoo! Finance CSV file will not return Dow Jones (^DJI)
  2. How to compare 2 JSON objects that contains array using Karate tool and feature files
  3. Has Yahoo suddenly today terminated its finance download API?
  4. karate-gatling report aggregation
  5. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  6. Syntax of Keras Functional API
  7. Save each sheet in a workbook to separate CSV files
  8. Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
  9. Why can’t a Flutter application connect to the Internet when installing “app-release.apk”? But it works normally in debug mode
  10. Export each sheet to a separate csv file
  11. Stock ticker symbol lookup API [closed]
  12. Basic API in golang antipattern?
  13. Instagram API: How to get all user media?
  14. presentRequestsDialogModallyWithSession does not work, but gives good result
  15. What is an API key? [closed]
  16. Address validation using Google Maps API
  17. Equivalent of define-fun in Z3 API
  18. How to retrieve ItemAttachment contents from Office 365 REST API?
  19. how can i make requests in a loop in soapUI with different content? [closed]
  20. How to post JSON data to FastAPI backend without using Swagger UI?
  21. Using Google Maps API to get travel time data [closed]
  22. Flutter FutureBuilder gets constantly called
  23. RESTful API Testbed with Swagger
  24. REST API – Bulk Create or Update in single request [closed]
  25. Yii2 REST query
  26. VBA WinHTTP to download file from password proteced https website
  27. Google Maps Web site and API : different results
  28. get releases empty in github api
  29. Using VBA and VBA-JSON to access JSON data from WordPress API
  30. Retrieve cover artwork using Spotify API

Leave a Comment