How to download file from URL?

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.

How to download file from URL URLDownloadToFile
Continue reading “How to download file from URL?”

XMLHttp vs WinHttp – speed comparison

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.

XMLHttp vs WinHttp - speed comparison fast and furious
Continue reading “XMLHttp vs WinHttp – speed comparison”

How to create XML file from scratch?

This is the third and the last part from the XML trilogy. Be sure You didn’t miss how to convert XML into Excel and how to overwrite XML file without copying or converting. In this article I’m going to show You how to create XML file from scratch.

How to create XML file from scratch?
Continue reading “How to create XML file from scratch?”

How to overwrite data in XML file?

In recent post I talked about converting XML data to Excel table. But what should You do to just overwrite data in XML file, without converting or copying it into Excel?

How to overwrite data in XML file?
Continue reading “How to overwrite data in XML file?”

Easy way to convert XML into Excel

When I was young I thought, that if You want to send table data You use Excel. Now I know that there are tons of ways of transferring data. One of them is XML. In today’s article I will show You an easy way to convert XML into more user friendly Excel.

Easy way to convert XML into Excel
Continue reading “Easy way to convert XML into Excel”