ytjjjtyj
11-10-2020, 08:38 AM
Hello,
I want to find the distances between 45 different places in my VBA code. (I think the use of google maps may help). But I need to find the best path to take from the first place to the last place.
For example:
If this is a map:
---------1--
-----2------
-----------3
If I found out that 2 was the most important place to start, I would then go to place 1 (since it is closer) then lastly place 3.
Is is possible to code this in VBA?
I want to find the distances between 45 different places in my VBA code. (I think the use of google maps may help). But I need to find the best path to take from the first place to the last place.
For example:
If this is a map:
---------1--
-----2------
-----------3
If I found out that 2 was the most important place to start, I would then go to place 1 (since it is closer) then lastly place 3.
Is is possible to code this in VBA?