A break from Word VBA .. and into Excel for mileage calculation

We have a staff handbook that we look after the updates of in work. Inside it is a large table of clients and the approximate mileages.  However, it needed a bit of an update, so I’ve found some code to automatically extract the mileage between two postcodes and display it in a cell.

So I’ll be knocking up a nice spreadsheet to bring both the raw data (extracted from Dynamics) into the spreadsheet and maybe add a simple GUI which will allow anyone using the spreadsheet to force a refresh of the data.

Makes a change doing some Excel VBA instead of the usual Word VBA 🙂