Save Internet File using XMLHTTP Object This function allows you to save an external internet file without using API calls or the Internet Explorer object. I need to download a CSV file from a website using VBA in Excel. How do i download a file using VBA (Without internet explorer) Ask Question.

This solution is based from this website: It is slightly modified to overwrite existing file and to pass along login credentials. Sub DownloadFile() Dim myURL As String myURL = 'Dim WinHttpReq As Object Set WinHttpReq = CreateObject('Microsoft.XMLHTTP') WinHttpReq.Open 'GET', myURL, False, 'username', 'password' WinHttpReq.send myURL = WinHttpReq.responseBody 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. Declare PtrSafe Function URLDownloadToFile Lib 'urlmon' Alias 'URLDownloadToFileA' _ (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, _ ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long Sub Example() DownloadFile$ = 'someFile.ext' 'here the name with extension URL$ = '& DownloadFile 'Here is the web address LocalFilename$ = 'C: Some Path' & DownloadFile!OR! CurrentProject.Path & ' ' & DownloadFile 'here the drive and download directory MsgBox 'Download Status: ' & URLDownloadToFile(0, URL, LocalFilename, 0, 0) = 0 End Sub I found the above when looking for downloading from FTP with username and address in URL. Users supply information and then make the calls. This was helpful because our organization has Kaspersky AV which blocks active FTP.exe, but not web connections.

Ps3 System Update Usb more. We were unable to develop in house with ftp.exe and this was our solution. Hope this helps other looking for info!