Urldownloadtofile fails

Normally https calls are no Problem from VB. For self signed certs, one has to send a certificate from file System or Windows cert store. 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 5 years, 11 months ago.

Active 2 years ago. Viewed 6k times. Teamothy 1, 3 3 gold badges 13 13 silver badges 19 19 bronze badges. Yes, the certificate for that URL us only valid for www. Perhaps this post helps? Thread starter farmerusingexcel Start date Jan 2, Hi guys many thanks for the forum I am trying to download historical rainfall figures for a meteorology station with dynamic station names and years these aren't issues at the moment. Unfortunately the website changes addresses daily for bulk historical rainfall downloads and as such leaves downloading only the individual years as zipped files.

Anyway, the download works fine when addresses are cut and pasted into a browser however when using vba URLDownloadToFile it only has intermittent successes and fails with most requests Still mostly fails with my firewall off, could it be on meteorology site end? Need a delay in my code? Any help appreciated code as below VBA Code:. Print msg Next year Debug. Print "" End Sub. Excel Facts. Easy bullets in Excel. Click here to reveal answer. Worf Well-known Member. Joined Oct 30, Messages 4, Welcome Can you post the page address where you click to download one of the zipped files?

I need to see the clickable element. You must log in or register to reply here. Similar threads. Learn more. Asked 7 years, 11 months ago. Active 7 years, 7 months ago. Viewed 4k times. I know that permission to write to the destination directory is not a problem. Wayne Wayne 1 1 gold badge 3 3 silver badges 7 7 bronze badges.

Add a comment. Active Oldest Votes. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.