Calculate distance between two points in excel using google api

Hello,

I need to create a excel spreadsheet per the following details:

Column A(Origin) Column B(Destination) Column c(Distance in km's (calculated by google route)

I have a list of 150 addresses(both Orgin and Destination) that i need to calculate the distance between in excel using the google route API.

example of this:

Origin Destination Distance in Km (google by Road)

Pinkenba QLD AITKENVALE QLD 4814 1,360

Pinkenba QLD ALEXANDRA HILLS QLD 4161 22

Could someone please assist me on how to do this?

Many thanks.

TIm

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

Replies (3)

KERGGA

I'm not sure who originally posted the code, but here is a link to code that should be helpful:

http://answers.microsoft.com/en-us/office/forum/office_2007-customize/macro-to-calculate-and-display-distance/58ef3b23-3f3a-446f-bf50-cb9b091052b3?page=1&tab=question&status=AllReplies&status=AllReplies%2CAllReplies

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

T.C.P

Thanks Keith,

Excuse my ignorance, but could you please provide me with a little more information as to how to incorporate the macro into a spreadsheet, then link it to the cells?

I'm very green in relation to macros!!

Regards.

Tim

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

BigMikeUK

Thanks for this. I have tried entering this code Excel has a problem with .send when I run it. Any suggestions please?

Calculate distance between two points in excel using google api

Replies (3) 

Question Info

Replies (3)