PDA

View Full Version : Draw Circles from Addresses v3.0



Eric Frost
02-13-2013, 12:33 PM
The latest version of this popular tool adds columns/options for setting the Pushpin Name and controlling whether the shape appears in front of or behind the roads.

Download here -- 747

Full source code is included for subscribers to the MapForums Downloads section ($99/year) (http://www.mapforums.com/upgrade.php).

Previous versions of this tool and related tools can be found here --

http://www.mapforums.com/draw-circles-addresses-new-version-19053.html

http://www.mapforums.com/drawing-drivetime-zones-around-list-lat-lons-11170.html

http://www.mapforums.com/drawing-circles-around-list-lat-lons-11167.html

http://www.mapforums.com/drawing-radii-circles-9991.html

I'll just let the pictures explain this tool. First, put in your addresses and set the properties of the circles you want to create.

http://www.MapForums.com/images/articles/draw_circles_worksheet.jpg

Click Begin, and it will open MapPoint and generate your map!

http://www.MapForums.com/images/articles/draw_circles_v3.0.jpg

Potential future enhancements could include the ability to add circles to an existing map as opposed to always creating a new map.

Another idea might be to have an option to set the relative order of the circles to control in what order the circles appear on the map relative to each other.

Let me know if anyone wants these features or others added to this tool.

Also, let me know what other tools or enhancements to existing tools you would like to see.

Eric

747

Tim Finnigan
08-12-2013, 02:03 PM
Hello Eric-
is there a tool to draw circles ( I need 25-50-100-200miles) around generic city names- not address,long lat?
Thank You

Eric Frost
08-13-2013, 06:24 PM
I modified the macro to work with Place Names, see attached.

Place Name is a single field, so if you have City and State is separate fields, those would need to be combined first. (My reasoning for doing this was that you can then also include other Geography Place names such as the example Statue of Liberty I threw on there).

Please give this a whirl and let us know if it accomplishes what you needed!

779

Eric

Eric Frost
09-16-2013, 11:48 AM
One user was having trouble using this.

They have UK Postal Codes and Cities, and are using MapPoint 2013 Europe.

The European version wasn't the issue, but the macro stops after it finds the first blank cell in the address column.

This can be changed at this line of the code --


'test to see if there is address in column 2 (B) for the current row
Do While Cells(nReadRow, 2) <> ""


Just change it to

'test to see if there is a name in column 1 (A) for the current row
Do While Cells(nReadRow, 1) <> ""


Even better, it could check all the columns to make sure it's a blank row before it stops, something like --


'test to see if there is a blank row
Do While Cells(nReadRow, 1) <> "" and Cells(nReadRow, 2) <> "" and Cells(nReadRow, 3) <> "" and Cells(nReadRow, 4) <> "" and Cells(nReadRow, 5) <> "" and Cells(nReadRow, 6) <> ""


Let me know if you have any trouble with this macro and I'd be glad to help!

Eric

proudfoot
09-17-2013, 02:04 PM
This is a fantastic tool. Well worth the yearly fee to download it. Made my life so much easier.

Eric Frost
09-17-2013, 02:12 PM
Let me know if there's anything else you'd request to automate things in MapPoint.

I know the tools in here are definitely not an exhaustive list of things that can be accomplished with MapPoint.

Customers are always welcome to request/suggest tools and (or contract with us at a reasonable rate for custom development!)

Erc