Postcode to Postcode Distance re-visited

[PhilD2GB]

Hi all,

Hoping you can help, I've done a lot of searching and can't quite find what I'm looking for.

I want to have 2 columns full of postcodes A & B, and column C to be distance between postcode in column A and postcode in column B using the driving distance.

I have a bing maps API key I want to use.

Can anyone suggest a simple macro that I could use so I populate columns A & B, click run and Column C is populated.

Do you know if there is a maximum per API call?

Or better still, from latitude and longitude 1 to latitude longitude 2

Thank you in advance.

[PhilD2GB]

As I need the postcode to postcode to each of them, possibly having a list in column A and the same list in row 1, then every cell between would be the distance between each one .

Postcode.png

[TMS]

See if this helps: https://chandoo.org/wp/distance-betw...xcel-maps-api/

[PrizeGotti]

Hi Phil,

As I don't have access to the Bing Maps API, I used a free alternative. Hopes this helps!

Usage:
=GetDistance(A1,B1)

Please Login or Register  to view this content.

[PhilD2GB]

Thanks both, great info.