Make your office life easier with simple and fast Excel VBA solutions.
I already described 2 methods how to download file from URL in one of my old articles. They are really good, but not the only methods. In this article I’m going to present the way to download file using WinHttp & ADODB method.
In this video we are going to get through the example of WinHTTP Request code to check the site status.
Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!
Until now I was only writing about HTTP methods, but did not really describe the final trick to download the file from URL. In today’s article I want to present You and compare two methods of downloading files from URL – URLDownloadToFile function and saving byte array to file method.
Time is money and money is time. Everyone wants to have better and faster macros. So do You. In today’s article I am going to do speed comparison between XMLHttp and WinHttp methods.
If You want to check if link is still active, You will just click it and see if site is online. But what should You do if You got 1000 links to check? Or more? In this article I’ll show You how to use WinHttp Request to get your site status.
