How to calculate Driving Distance Matrix on Excel using Bing Maps API

Excellent hemant, just one observation though - Since api keys have limits, every call is precious. Hence filling only the upper half of the diagonal would have been wise. Also from efficient programming perspective it is important

Thanks great help, can u check the same can be converted into AddIn, i was unable to do it

This works perfectly, Thank you so much Hemanth. When im working on a larger data set it takes quite a lot of time for it to fetch the distance, is there any work around for that?
TIA.

hi it was used full to me but it is not working on my excell
pls give excel which is red to used

This is exactly what i needed. Thank you for explaining very clearly

where will i get all coordinates ??

not working, value error

How to get coordinate automatically trough excel?

Very Helpful video, Thank you !

Hi, excellent tutorial. Would you help me .the negative coordinates of the error how do I?? positive coordinates works. thanks🙂

right now the calculation automatically grabs the shortest distance and not the interstate distance. how could I change the VBS Module to show the shortest interstate distance? But thank you very much for this so far

Need 2 pincode distance

This is amazing and very, very helpful for me. Thanks a lot for the well elaborated explanation.

Thanks Hemanth, Very helpful

What if i don't have the coordinates?

Thanks for your video clip

Hi Hemanth, this is a wonderful video. It really saved a huge amount of time for me.

Awesome - thank you!!

Excellent👍

Hi How did you connect database to sheet one. Can someone please help me out with the formula.

Desde Mexico.... funciona al 100%

Hemant thanks a lot. Its helping a lot. Like function GetDistance can you help with GetTime as well?

excellent video

its not working plz help

Thanks for the Video! But how do i get the field like B11 and which are necessary for the automasation to fill out the Matrix??

Hi! I used the formula and everything worked perfectly well for a while. Now, excel isn't recognizing the formula anymore. Do you have any advice on how to solve this?

I want to do something similar. I want to know the distance travelled by the train from station A to station B. Please tell me how to do it.

Much appreciated it was very helpful, I was looking for this formula too many weeks and my manager he was very impressed about it 🤍

im getting a theres a problem with this formula error. Can you help me please

Awsome dude 😮

您好，我获得了负距离。这是什么原因

Thanks for this Video ...

pls share code

Hi, I really love your tutorials, but why do I get the output "-1" instead of the real travel distance? I already did exactly the same as shown in your video. Thank you

Can you share the link....of the code pls......hyperlink is missing

can this method be used for 80 locations?

Hi.. Can we get the distances by pincode to pincode

Hey, why the marix is not symmetric ?

This code is working for India's coordinates. But it is not working for USA coordinates.
Please help.

Thank You

how to do this between pincodes within the city?

thank you very much for the knowledge. you've helped me in many ways.

Why we used this all it's all available in map when we enter two cities distance in map it's showing

Hey
Great work! I used your code for two years now. But with the change to Azure Maps I don't get this think working anymore... can you make a new video where you explain how to use Azure Maps API instead of Bing Maps?

Hi ... i cant create a bing key. It s not working anymore...any help?