The procedure below may however prove more efficient as it will download the file in 128 byte chunks of data instead of a single stream. In these cases the above procedure won’t do. might want to interrupt the process, enable the user to interact with Excel (DoEvent) etc.
In some cases you will need to download large files (not text/HTML) and will want to be able to control the process of downloading the data e.g.