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.
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 ...
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.
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.
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?
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 ~
There are currently 1 users browsing this thread. (0 members and 1 guests)