non-developer here. Migrating from Bing Maps to Azure, Need help getting a map API to use in Excel for distance calculation

Question

I am a non-developer so I don't write code. I have an Excel sheet that currently uses Bing Maps generated API key to calculate a distance between home and a local address. I understand that Bing Maps is going away and I Need to transition to Azure. Can anyone tell me in easy to understand/implement language, what I need to do in Azure and change in my Excel so I can still do this distance calculation?

Here is the line I use in Excel:

=GetDistance((IF(C63="Home",$C$2,0)),(IF(OR(ISNUMBER(SEARCH("home", D63)), ISNUMBER(SEARCH("virtual", D63))), $C$2, E63)),$B$1)*2

Many thanks in advance

Answer 1

You will need to edit the getdistance function to call Azure-maps route API. If you are not the developer, you will have to reach out to whomever created that for you or share the VBA code here and we can suggest the new call. There is a third party site that has a similar setup https://www.exceldemy.com/calculate-distance-between-two-addresses-in-excel/