Downloading An Excel File From The Web

// Downloading An Excel File From The Web

Downloading an Excel file from the web

What to do when the file name changes monthly?

By Jeff Robson

Client problem: how to download an Excel file each month containing foreign exchange rates when the file name changes all the time.

Here, you can’t just record a macro to get the code you need.  You must write a little VBA to get this done.

The solution we provided allows for input of all parameters on the setup sheet using various fields (e.g. [StartMonth]).

These are then replaced by the VBA code when it runs with the actual values from the sheet to generate a flexible file name and URL.

The end result is a very flexible macro that could be very easily adapted to almost any situation.

Download Excel File

2017-03-08T03:54:04+00:00 VBA – Macros|