Excel - Google Maps API Distance Calculator

Hello,

It seems to only work for areas in Netherlands.

I was also interested in seeing if it would work with the Google API insteas (as I imagine this would run a lot cleaner).

Thanks for the help.

@maczaq

I saw that code but I wondered if someone who knew what they were doing could adapt the code so that it would be used as a function within the worksheet. This way I could define the start and end destination from 2 different cells and then display the results in a 3rd cell.

Thanks again for the help.

Phil.

Hello,

I have finally got it working thanks to all of your help!

I would like to turn it into a UDF where I can call it using =GetDistance(A1, A2) where A1 contains start destination and A2 contains end destination and the function will return the distance. Im not to bothered about the time part at the moment.

If anyone could shed some light on how to convert this brilliant code to a UDF then please help.

I have attached what I am currently using. - __postcode country google snb 2.xlsm

Please Login or Register  to view this content.

Thanks again everyone

phil.

Works like magic,

Thank-you very much! Finaly got there after about a week of not giving up.

I am just wondering whether the same thing can be applied through the Google API?

Regards,
Phil.

yes, but it's not much faster and breaches the terms and conditions of the service

Interestingly the code is only working if source address is based in the UK.
I am looking for the same working in the netherlands. Unfortunately changing the url to *.nl is not working.
Any ideas?

Hi, new user here.

How can I modify this code to use the US Google Maps?
Also, I would like to setup name shortcuts (ie Name = Complete address of location) and have Google Maps be able to calculate, is that possible?

Thank you in advance!

Very interesting function! Only thing is that I get an error for "can't find project or library" (Excel 2010) and adding the Xml 6.0 as a reference does not solve it

Previous Error I got for the Excel as posted in the tread - when I build a customfunction - I always get "0" as an asnwer...

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.