“My location” function for Excel

If you downloaded the example file I posted earlier on today, as well as a few updates to the simple versions of the Gmaps and geolocation functions for Excel, you may have noticed that one of the places on the clickable list of locations was “My location”. This works using Wikimedia’s geoiplookup service. When I […]

Google Maps and Excel download

I was asked for a downloadable file with the G_LATLNG function by Filipe who was having trouble getting the function working. Since I posted that, I’ve done a bit of further work to improve it. The workbook you can download caches results from G_LATLNG and G_DISTANCE queries to reduce the amount of time spent polling […]