Find the distance between Zip Codes

Hi All,

Hope you are doing well!...I am trying to find the distance between the origin Zipcode and the destination zipcode...Can you please help me here...Please find attached the zip code file with origin and destination zipcodes....

Can you please help me here!...

Thanks,
Arun

Driving distance or distance as the crow flies?

@kyle123: Its the driving distance...

Here:https://www.excelforum.com/tips-and-...rivetimes.html

@Kyle123: Really appreciate your response!...I used the function in VBA in a module and inserted my microsoft key..Can you please let me know how to call the function for my data (2000 rows of origin and destination zip codes)...Really appreciate your help!

Just use it as an Excel function, something like:

Please Login or Register  to view this content.

@Kyle 123:Yes its working now!...Is it distance in Kms or miles...can you please let me know!..

@kyle123:Can you also please let me know the way to go about doing using the Google API

No, sorry - it breaks the Google terms and conditions.

It's in Km