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 4 of 4

Using the radius tool, I would like to import a li....

This is a discussion on Using the radius tool, I would like to import a li.... within the MapPoint Desktop Discussion forums, part of the Map Forums category; Using the radius tool, I would like to import a list of addresses and have MapPoint display only those that ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Using the radius tool, I would like to import a list of addresses and have MapPoint display only those that are outside a 50 mile radius around a point.

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    There are a couple of different ways to approach this, but the easiest one is probably to import all addresses, add a 50-mile radius circle on the map, use this to export all addresses INSIDE the radius to Excel, and then do the little bit of work required in Excel to "subtract" these rows from the total data set.



    If you're willing to do some programming, you could of course perform all the work inside MapPoint. In that case you would plot all addresses, do a simple distance calculation from each point to your chosen centerpoint, and export only those points that are >50 miles from the centerpoint. Very easy, probably no more than a couple of hours work for somebody familiar with the MapPoint object model.

  3. #3
    washuromeo is offline Junior Member White Belt
    Join Date
    Apr 2010
    Location
    Atlanta, GA
    Posts
    4

    Re: Using the radius tool, I would like to import a li....

    I'm new to programming. Where might I find the visual basic code for that?

    I'm trying to program in Excel's visual basic to return the shaded area (data that is mapped within the mappoint map, like population) back to excel via a macro. Any thoughts?

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

    Re: Using the radius tool, I would like to import a li....

    Do you have MapPoint 2010? There's a lots of new methods including ExportToExcel --

    Methods
    The new methods for Microsoft MapPoint 2010 are:

    ImportGPX (Application and MappointControl objects)

    ExportGPX (Application and MappointControl objects)

    Reverse (Route object)

    UpdateConstruction (Route object)

    ZoomTo (Route object)

    BasicRenderingOnly (Map object)

    DefaultRendering (Map object)

    ShowInOnlineMap (Map object)

    SendToMobile (Map object)

    ExportToExcel (SelectedArea object)
    ~ 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. Pushpin Tool
    By davidb in forum Products: Pushpin Tool, Single State Mapper
    Replies: 5
    Last Post: 03-19-2010, 12:32 PM
  2. Integrating MapPoint into CRM Web Tool
    By Anonymous in forum Bing Maps and MapPoint Web Service
    Replies: 1
    Last Post: 04-03-2005, 08:51 PM
  3. Pushin Tool Version 2.4 Now Available
    By Eric Frost in forum Products: Pushpin Tool, Single State Mapper
    Replies: 1
    Last Post: 09-03-2003, 01:32 PM
  4. PUSHPIN TOOL
    By gsc1ugs in forum Products: Pushpin Tool, Single State Mapper
    Replies: 10
    Last Post: 03-07-2003, 11:08 AM
  5. I just downloaded the Tool Spatial data import too....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-30-2001, 08:05 AM

Tags for this Thread

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