This was prepared by request, it allows you to set up a list of lat/lon's in Excel and draw drive-time zones around each location. You can specify the color and number of minutes for each location.
Enjoy!
Eric
This is a discussion on Drawing Drivetime Zones Around a List of Lat/Lon's within the MapForums Plus Downloads forums, part of the MapForums Plus category; This was prepared by request, it allows you to set up a list of lat/lon's in Excel and draw drive-time ...
This was prepared by request, it allows you to set up a list of lat/lon's in Excel and draw drive-time zones around each location. You can specify the color and number of minutes for each location.
Enjoy!
Eric
~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
~~
~ Upgrade to Get Access to the MapForums Downloads ~
I created a new version of this for a MapForums Plus member who wanted to be able to specify an existing map and add the new drivetime zones on top of the existing map. If this would be useful to anybody let me know and I'll post the new version.
~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
~~
~ Upgrade to Get Access to the MapForums Downloads ~
Could this marco be adjusted to provide the option to hide the drivetime size label? I saw that this option exists on the circle around a long/lat. The labels are hiding the drive zones in my application.
Thank you.
Hi Nolster!
Thanks for your patience.
I have added this as an option for each row, see attached.
Drivetimes_Around_LatLon_v2.zip
Just fill in "FALSE" for all the rows if you do not want the Size to show for any of the drivetime zones.
Eric
Drivetimes_Around_LatLon_v2.zip
~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
~~
~ Upgrade to Get Access to the MapForums Downloads ~
Now that all of the drive time labels are hidden, I can see there is an issue with borders. This I fixed myself, just manually making the border color the same as the zone color inside the VB code. Works great at this point. Thank you for your help.
BTW - we are mapping nationwide, to show clients points of presence coverage against contracted drive time. Works incredible.
Eric
This looks like just what I need - I'm not a VBA expert, so it would be good to have some guidance on three points - any changes required for 2013 version, any changes required for Europe map and how could I make it use postcodes rather than lat long. Very many thanks in advance.
Kirsten
Do you mind to share 10 or so sample postcodes? I will prepare a new tool that works with postcodes and test to make sure it works properly with MP13EU.
Eric
~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
~~
~ Upgrade to Get Access to the MapForums Downloads ~
Eric
Thanks for this - here are some sample postcodes:
G31 4EB LS11 5BJ CV3 4AR OX4 3JP TQ2 7AN TR10 9LY NR6 5DT CT11 7PR E10 5NH RG30 4EL
Kirsten
Sorry - should have looked at preview first - these should read, for example, G31 4EB.
I took a quick stab at this, see attached.
This doesn't have all the bells & whistles of some similar tools I did recently e.g. all the options in this tool -- Draw Circles from Addresses v3.0 but let me know if you want them and I can certainly add them for you.
Eric
~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
~~
~ Upgrade to Get Access to the MapForums Downloads ~
There are currently 1 users browsing this thread. (0 members and 1 guests)