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 🙂