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

Exporting Multiple Radii

This is a discussion on Exporting Multiple Radii within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have used the code in the newsletter tutorial 5 at mp2kmag.com/update/mappoint.newsletter/2007-04-10 to create a set of pushpins with radii ...

  1. #1
    tjgray06 is offline Junior Member White Belt
    Join Date
    Oct 2007
    Posts
    3

    Question Exporting Multiple Radii

    I have used the code in the newsletter tutorial 5 at mp2kmag.com/update/mappoint.newsletter/2007-04-10
    to create a set of pushpins with radii around them.

    Does anyone know how to export all these radii at once to Excel (since I have to do it for a lot of them) using VBA. This could be as the radii are originally drawn or at the end after all have been drawn. I really don't wan't to have to manually click on each of them.

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

    Re: Exporting Multiple Radii

    Hey TJGray06,

    I've downloaded the zip with xls and have run it.
    I click on a circle and there is no option to export.
    Please explain further what it is that you're after.

    Mike Mattys

  3. #3
    tjgray06 is offline Junior Member White Belt
    Join Date
    Oct 2007
    Posts
    3

    Re: Exporting Multiple Radii

    Try making the radii bigger (40). At that point, you should be able to click on them and "Export to Excel." This will cause all four pushpins to show up in the exported file since the circle encloses all of them.

    Basically, what I want to do is use the import wizard to put data by zip code on the map (which I can do), add a bunch of radii (which the program does), and export the radii to determine which zip codes are included within them. The question is how to export the radii using VBA so that I don't have to manually click on hundreds of them and export.

    Thanks.

  4. #4
    tjgray06 is offline Junior Member White Belt
    Join Date
    Oct 2007
    Posts
    3

    Re: Exporting Multiple Radii

    I got it figured out. Basically you just have to use the QueryCircle method and then copy its contents to cells in Excel.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. New user: Exporting multiple data sets to excel
    By rpone605 in forum Products: Pushpin Tool, Single State Mapper
    Replies: 0
    Last Post: 06-20-2006, 04:54 PM
  2. creating radii based on highest concentration of pushpins
    By tvsmvp in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-31-2006, 06:10 AM
  3. MapPoint VBA - Radii
    By Phil Holt in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-24-2006, 08:26 AM
  4. Exporting Help
    By Circpro in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 01-19-2005, 08:10 PM
  5. please help exporting !
    By ToddF in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 04-26-2004, 12:12 PM

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