Excel vba code to download file from web

As mentioned in my PM, I couldn't get the WinHttpRequest method to work - Excel seemed to be caching the requests because Fiddler wasn't receiving them which made debugging and investigating the problem almost impossible. I've created a macro to download some files from a webpage. The thing is I can only scrape the links to those files. As I never worked with downloading files from websites, I got stuck and can't go ahead. Any help as to how i can accomplish this will be greatly appreciated.

However, in the sample workbook, I have included some error handling if-clauses to avoid illegal characters and invalid file paths. The VBA code for the primary procedure is given below:. Below is the VBA code of two auxiliary macros for showing the folder picker dialog and cleaning the main sheet to be reused. Note that if you try to download large files or your internet connection is slow, the workbook might take some time to complete the download. However, in any case, the message box at the end of the procedure will inform you that the downloading has finished.

The short video below shows how the sample workbook is used to download two files from Dropbox. Motivated by some emails that I received from various blog readers, I decided to develop another version of the sample workbook. As the above image shows, the updated version allows the user to define a file name for the downloaded file.

However, apart from the file names, the user should also define and the file extensions ; for example, Test. The user then will have to add the extensions manually. The zip file contains both workbook versions the old and the updated ones. The files can be opened with Excel or newer. Please enable macros before using them.

Page last modified: September 28, I founded this site back in intending to provide solutions to various engineering and programming problems. I do have a question though, is this file suitable to download a shared file from SharePoint?

Thank you!. Ruth Lang's Ownd. Excel vba download csv file from web. Download a file from url using VBA. But you will need to change saving path, file type etc. It will be helpful if you can post your current code. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 4 years, 1 month ago.