Hello... I'm looking for a way to have Excel look up and return the driving time and distance for two points using Google Maps. I've seen on this forum and others that it can be done. I'm pretty good with Excel. But, I'm terrible with code. The only solutions I have found while searching involve a lot of code. I'm sure that's probably the answer. But, I would appreciate if someone could spell it out for me or post a file that I could examine. I'm using Excel 2010. Thanks greatly!
A1=Start Address
A2=Destination Address
B1=Driving Time
B2=Distance
I've seen it a few places... One was on this forum from a couple years ago:
http://www.excelforum.com/excel-gene...ing-times.html
Google Developer:
http://code.google.com/p/spreadsheet-data-connector/
And, I know an acquaintance who has done it. Though, he isn't sharing the knowledge. I'm trying to add to a program for the fire department that will aid in planning by showing the driving time and distance from each firehouse to a location. Currently, the spreadsheet I use will return the order of arrival. I have to manually go into Google and look up each station to each geozone centerpoint. This is a large department with 67 fire stations and 550 geozones. I'm hoping to automate the process, rather than do 36,850 separate searches in Google Maps.
Bookmarks