Url download to file vba

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?

If you want to download from SharePoint, you have to be logged-in first. However, this cannot be done with the VBA code shown here. Hi Christos! Great job with this file! Any other solution? Thank you for pointing out the issue. It seems that for some unknown reason, Google accidentally marked the file as a virus! I have updated the link, so now you will be able to download both files.

Thanks for this wonderful file. In and ideal world I would have a macro that when the user clicks the button in the report workbook it would automatically to the following steps: 1.

I'm sorry I have nothing more to give on this, but any help at all would be very welcome. Thanks GillB. Deepak Excel Ninja. Mainly WinHttpReq. Send stops due to firewall blocking outgoing connections. So, check with your firewall. Nothing getting downloaded from given URL. Hi, GillB! CSV format. Besides, if you're running Windows Vista or higher you won't be able to directly writing on drive C, so if the error is at the save line, try changing the path to something like: c. PS: To get rid of those differences you can use this as full path: Code:.

Last edited: Mar 26, Thanks to both Deepak and SirJB7 for the above. A few responses to the above; Deepak: - the Url doesn't work because I deliberately made it not to work - there is sensitive information in the download, so I couldn't share it correctly. You're welcome. You must log in or register to reply here. Similar threads J. JumboCactuar Apr 15, Excel Questions. Replies 2 Views Apr 15, Eldrod.

Hawk11ns Sep 18, Excel Questions. Replies 0 Views 1K. Sep 18, Hawk11ns. Question Handling errors from a WinHttpReq function. Replies 3 Views 1K.

Show 1 more comment. Cole Busby Cole Busby 6 6 silver badges 17 17 bronze badges. Don't know if that was obvious to other people or not.

DRC i know your comment is a year old at this point, but I wrote this almost 3 years prior. We had imported some other things in our scripts at the time, but im happy you got some help!

A modified version of above to make it more dynamic. AndrewK AndrewK 61 3 3 bronze badges. When answering an old question, your answer would be much more useful to other StackOverflow users if you included some context to explain how your answer helps, particularly for a question that already has an accepted answer. See: How do I write a good answer.

A modified version of above solution to make it more dynamic. FolderExists CreateObject "Scripting. Users supply information and then make the calls. We were unable to develop in house with ftp. Hope this helps other looking for info! Thank you for your interest in this question.