Hi all,
I am a newby to this forum and Excel databases but would like some information on using a function in excel 2007 to retrieve results from Google maps "Get Directions" and insert/update my excel 2007 database of UK Locations with the relevant "Mileage and Time" results.Book1.xlsx
My excel database consists basically of 5 columns: (Example)Book1.xlsx
A1: From, B1: Location, C1: County, D1: Area, E1: Type, F1: Mileage, G1: Time
Note: Column A "From" would always be the same value (start point address)
I would obviously like the results of Mileage and Time in the relevant cells (F1 and G1) per row, however my database consists of 16,000 records and therefore would be very time consuming by inserting manually.
Is there such a code and can this be achieved?
Many thanks in advance
Bookmarks