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

need macro to export points inside multiple radi on map to excel

This is a discussion on need macro to export points inside multiple radi on map to excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; Mappoint 2006 After much searching I located a macro that allows me to import multiple locations from excel and automatically ...

  1. #1
    RandyG is offline Junior Member White Belt
    Join Date
    Jul 2009
    Posts
    2

    need macro to export points inside multiple radi on map to excel

    Mappoint 2006
    After much searching I located a macro that allows me to import multiple locations from excel and automatically draw a radius around the points. A great help! Next I import other data points to my map and determine which ones are inside/outside my radi.

    I need a macro that will identify all points inside all radi on the map and export the data (name, city, state for example) to excel. Perhaps i don't need a macro? I'm familar with the mappoint export funtion but I can't figure out how to sellect all radi and export the points inside. Ideally, I'd like a worksheet that list points that are inside and those that are outside the drawn radi.

    Any help is appreciates! (my first post here)

  2. #2
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    Re: need macro to export points inside multiple radi on map to excel

    Hi Randy,

    There isn't a macro or programmatic command to Export To Excel,
    so this will have to be done using custom programming.

    Mike Mattys
    Mattys Consulting - Custom Programming

  3. #3
    davidb is offline Senior Member Blue Belt
    Join Date
    Oct 2003
    Location
    London
    Posts
    290

    Re: need macro to export points inside multiple radi on map to excel

    I had a similar project a few months ago when I had a London property dataset of approx 3500 locations and I needed to be able to draw radii around tube stations and output all properties in each of the radii along with their associated data fields. The only difference with what you’re after is mine included duplicates (many properties were within a radius of more than one station). Anyway I put together some rough code in excel vba to do it and if you’d like me to dig out a copy of the excel workbook then please let me have your e-mail. If I remember rightly I tried to write the code in a reasonably generic way, so it should get you started.
    My contact details are on my website Contact Broom Analysis
    David
    UK mapping and map analysis services at www.broomanalysis.plus.com

  4. #4
    RandyG is offline Junior Member White Belt
    Join Date
    Jul 2009
    Posts
    2

    Re: need macro to export points inside multiple radi on map to excel

    David,
    thank you. I've sent you a message with my email. The worksheet with the VBA code may be enough to get me started on my project. Thanks again.

    To all,
    I've enjoyed the forum and picked up some great tips already. Thanks!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using a macro to get a map into excel
    By jimbob in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 03-19-2009, 05:21 PM
  2. Replies: 0
    Last Post: 07-20-2008, 05:58 PM
  3. Excel to Mappoint Macro
    By Paddy1979 in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 06-12-2008, 10:53 AM
  4. Macro to Export to Mappoint (from Excel)
    By infinityukok in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 08-03-2007, 07:39 AM
  5. updatelink using macro in Excel XP
    By amyles in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-17-2003, 02:26 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 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127