Excel Function to get distance between two latitudes and longitudes from Bing Geocoding API

[Exceluser15]

Hello ,

I require some help in writing an excel function that calculates the distance between 2 lat and long of addresses using BING Geocoding API and returns the value in a new column.

So, basically, the excel to connect to www.dev.virtualearth.net and get me the results

Ex: Latlong 1 Latlong 2 Distance

37.5583883 -122.0593183 37.57257 -122.04792 ????

I need the distance to get calculated automatically for >1000 rows of lat and long of addresses.

Can someone help me with a code for this?

Thank you so much,
ExcelUser15

 

[Kenneth Hobson]

Welcome to the forum!

Are you asking for a solution or for a solution using your approach?

If the latter, the link is invalid for me. If the former, no API is needed. See: Latitude And Longitude

 

[chicagocomputerclasses]

Do you need driving road distance or longitude-latitude distance? If it's the 2nd one then no API is needed.