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

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

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?

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

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

how to do this between pincodes within the city?

Thank You

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

Hey, why the marix is not symmetric ?

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

can this method be used for 80 locations?

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

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

pls share code

Thanks for this Video ...

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

Awsome dude 😮

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

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

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.

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?

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??

its not working plz help

excellent video

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

Desde Mexico.... funciona al 100%

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

Excellent👍

Awesome - thank you!!

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

Thanks for your video clip

What if i don't have the coordinates?

Thanks Hemanth, Very helpful

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

Need 2 pincode distance

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

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

Very Helpful video, Thank you !

How to get coordinate automatically trough excel?

not working, value error

where will i get all coordinates ??

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

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

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.

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

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