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.

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

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.

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