MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Exporting Multiple Radii

This is a discussion on Exporting Multiple Radii within the MapPoint 2006/2009 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 ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 10-17-2007
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 10-18-2007
Senior Member
Blue Belt
 
Join Date: Dec 2002
Posts: 217
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 10-18-2007
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 10-19-2007
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
New user: Exporting multiple data sets to excel rpone605 Products: Pushpin Tool, Single State Mapper 0 06-20-2006 03:54 PM
creating radii based on highest concentration of pushpins tvsmvp MapPoint 2006/2009 Discussion 1 01-31-2006 05:10 AM
MapPoint VBA - Radii Phil Holt MapPoint 2006/2009 Discussion 2 01-24-2006 07:26 AM
Exporting Help Circpro MapPoint 2006/2009 Discussion 0 01-19-2005 07:10 PM
please help exporting ! ToddF MapPoint 2006/2009 Discussion 2 04-26-2004 11:12 AM


All times are GMT -5. The time now is 01:30 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Turkey Cheap
Trips to Turkey are cheap when you book with Holiday Hypermarket. Sunshine, nightlife, cuisine and culture, Turkey has got it all.

Business Travel Agent
Leading Business Travel Agent. Personal service is at the heart of our business. Talk to one of our travel agents today.

Holiday Italy
A Holiday in Italy can mean many different things to many different people. This diverse country has an abundance of art, wine, food and stunning beaches. Book online today.

Bahamas Holidays
Bahamas Holidays offer pure blue skies, soft white beaches and the holiday of a lifetime. Visit us for a great deal to the Bahamas.

Cheap Greece Holidays
For cheap Greece holidays make sure you know when to book and who to book with. Visit ulookubook.com to get help with doing both of those things. Why not time your visit with a Greek festival?

Holiday Comparison
We can help you with holiday comparison when you check out the options at Travel.co.uk

Holidays in Cyprus
Visit the tombs of the island kings! Visit On The Beach for information on holidays in Cyprus.


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