Maps with Macro/VBA

Hello,

I'm looking to make an excel workbook that would be used to determine the closest route to a terminal market. Here's the rundown:

I'm a farmer looking to find a way to find the best or closest location to move a rejected load of product. For example, if a load of produce gets rejected in Atlanta, GA I would like to enter the location of the truck, and run an active x control with VBA to open a 3D map with all of our market locations in one color, and our truck in the other color. I have all of our market locations in a spread sheet already. It doesn't necessarily have to show the route, but if we can get a visual of what's closest that would be extremely helpful.

I know that you can't do run VBA with 3D Maps, but is there any other way to get these results?


If anyone has any ideas on how to execute this, I would really appreciate it!


Kamden

I think that you are looking for a Googlemaps API

First look through the options, then come back and get help for the code

https://www.mapspeople.com/blog/maps...xoCQxsQAvD_BwE