Search results
25 maj 2017 · The link above is to the Distance Matrix API, which will help with working out distances between 2 points. The results from this will be based on travel (so driving distance), this may or may not be what you want.
19 lip 2018 · Ever wanted to calculate distance using Excel? Use Google Maps or Bing Maps API in Excel WEBSERVICE() to get distance & travel time between two addresses.
28 mar 2023 · This example macro calls the Distance Matrix API with 4 different postcodes - 2 origin postcodes and 2 destination postcodes. The API's response contains the results for each pair: 4 distances in km and durations in hours and minutes, which are output to the VBA Immediate window.
20 lis 2015 · The only way that I'm aware of to make this possible is to have a pre-built list of postcodes with x y z co-ordinates. You would then need to use an INDEX() of some sort to extract the two x y z co-ordinates based on your post codes being row references & sum the difference to convert into miles.
15 mar 2023 · Does anyone have a vba code that I can insert my own Bing or Google API code in that will return the distance between 2 UK postcodes? I want to create a table that has static postcodes pre populated using VLookup. So the users enter 1234567 in the store code box and the address details pull through.
13 cze 2022 · Here is an overview of how the distance between two addresses can be found in Excel. How to Calculate the Distance Between Two Addresses in Excel: 3 Ways. In our dataset, we have the Latitude and Longitude for Ohio and Alaska. We will measure the distance between them.
17 lut 2021 · VBA to get distance between two Postcodes using Bing API giving 400 error on certain lines.