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
Bookmarks