I have updated the add-in to make it more stable and to provide further functionality. The add-in works with Excel 2010 and above (I have not tried earlier versions as I don't have the software).
The functions and usage are as follows:
Gets kilometres between two postcodes
Gets miles between two postcodes
Gets Latitude for postcode e.g. NN14 2JD = 52.4472546
Gets Longitude for postcode e.g. NN14 2JD = -0.82291
Gets duration in hours and decimal of hours e.g. 1.2 is actually
1hr 12mins N.B.
|Gets a list of driving directions between two postcodes|
Gets a summary of the journey between two postcodes in duration and distance.
|Gets a Google Maps url showing the route map of journey|
Please remember: these functions will ONLY work with UK postcodes.
An example: =GetMiles("NN147RJ","ST52SL") will return 108.01 miles.
***The postcodes need to have quotes around them as above***
The installation is easier than it was. Just download the file and unpack it. Open Excel and go to File>Options>Add-Ins. Click on the 'Go..' button at the bottom and then browse for the XLL file you unpacked from the archive - the rest is straight forward.
You can download the new file from here: Excel_Addin