Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 7 of 7

Draw Circles from Addresses v2.0

This is a discussion on Draw Circles from Addresses v2.0 within the MapForums Plus Downloads forums, part of the MapForums Plus category; NOTE: A new version of this tool is now posted here -- http://www.mapforums.com/draw-circle...html#post52244 ___________ Variants of this tool have already ...

  1. #1
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Draw Circles from Addresses v2.0

    NOTE: A new version of this tool is now posted here -- Draw Circles from Addresses v3.0
    ___________
    Variants of this tool have already appeared in the MapForums Downloads section.

    screenshot.jpg

    In this new one, it draws a Pushpin and Radius for each address, and it now lets you specify more parameters than ever, notably Country.

    parameters.jpg

    This should now work with both the NA and EU versions, and in multiple countries in one pass.

    Lots more could still be done with the tool. Only a limited number of colors are supported.

    The ZOrder could be specified as well as have an option not to draw the Pushpin.

    Also, in the version attached, you always have a line. Actually if you have a Fill, MapPoint would allow you not to actually have any line, but this tool does not have a way to do that. (Nonetheless, you could make it a thin line with the same color as the fill which would accomplish the same thing.)

    Anyway, now I'm rambling. Try it out and let us know how it works for you and if you have any requests.

    Download here -- Draw_Circles_from_Addresses_v2.0.xlsm.zip

    best,
    Eric
    Last edited by Eric Frost; 02-13-2013 at 12:35 PM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  2. #2
    tsims is offline Junior Member White Belt
    Join Date
    Dec 2012
    Posts
    3

    Re: Draw Circles from Addresses - NEW VERSION

    This file has been quite useful for us. However, is there any way to toggle the circles after they have been created? Using the hide feature only makes the pushpin disappear and not the circles?

  3. #3
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Draw Circles from Addresses - NEW VERSION

    Great! Thanks for the feedback.

    There's no way to "Hide" shapes in MapPoint.

    You can delete them, but then you have to re-create them.

    Is that OK? What if I give you a tool to Delete all shapes on a map? Would that accomplish what you need?

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  4. #4
    tsims is offline Junior Member White Belt
    Join Date
    Dec 2012
    Posts
    3

    Re: Draw Circles from Addresses - NEW VERSION

    That might be useful. Also, I'm getting an error when I click the Map It button that says:

    Run-time error '-2147217383 (80041019)':
    Method 'FindAddressResults' of object '_Map' failed

    Any suggestions?

  5. #5
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Draw Circles from Addresses - NEW VERSION

    I'd have to troubleshoot this for you. Is it hanging up on a specific address or does it always give this error?
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  6. #6
    tsims is offline Junior Member White Belt
    Join Date
    Dec 2012
    Posts
    3

    Re: Draw Circles from Addresses - NEW VERSION

    Always giving this error. Whenever I import this data set (without using the circles template) there is a bunch of unmatched data that I have to manually match. I'm guessing that this is what may be throwing the error code, but I'm not certain. How does the code handle unmatched/unfound addresses?

  7. #7
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Draw Circles from Addresses - NEW VERSION

    Thanks for sending me your file, I took a look and saw it working down the list and getting stuck at a P.O. Box.

    To get past this, I added a couple lines of code around the FindAddressResults line, see below.

    This way it will just it should just ignore any it cannot find.

    Code:
        On Error Resume Next
        Set objLoc = objMap.FindAddressResults(szAddress, szCity, , szState, szZip, szCountry)(1)
        On Error GoTo 0
    hope this helps!

    By the way, how are you using the tool for your business? Would you be interested in writing up some paragraphs to share your MapPoint Story and be published in an upcoming MP2K Magazine newsletter?

    http://www.mp2kmag.com/update/
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 03-09-2012, 07:26 PM
  2. How to add the layers in bing map version 7.0 as we add by using the VEShapLayer in version 6.3
    By vipulsinghal2006 in forum Bing Maps and MapPoint Web Service
    Replies: 3
    Last Post: 05-17-2011, 12:05 AM
  3. Drawing Radii (Circles)
    By Eric Frost in forum MapForums Plus Downloads
    Replies: 11
    Last Post: 10-20-2009, 02:40 AM
  4. Shaded Circles
    By dgermain in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-12-2007, 12:42 PM
  5. Circles
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 12-09-2003, 12:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96