MapForums

Anonymous · #1 (**permalink**) 07-30-2002

Is it possible in MapPoint to import a set of AutoRoute push pins and then to export (to Excel) the pushpin details within a defined radius of a postcode/zipcode?

Anonymous · #2 (**permalink**) 07-30-2002

Anthony,

I'm assuming you can import the pushpins to start with and later export some data to excel. So here is how I would enumerate the pushpins within a given radius (100 for example) from a zipcode.
I'm using the ActiveX Control named MappointControl1 in VB6

Dim objmap As MapPointCtl.Map

Dim objDataSet As MapPoint.DataSet

Dim objRecordset As MapPoint.Recordset

Dim objLoc As MapPointCtl.Location

Set objmap = MappointControl1.ActiveMap

Set objLoc = objmap.FindAddress("", "", "", THEZIPCODEGOESHERE, geoCountryUnitedStates)

Set objRecordset = objDataSet.QueryCircle objLoc, 100)

objRecordset.MoveFirst

While Not objRecordset.EOF
msgbox objRecordset.Pushpin.Note & vbCrLf

objRecordset.Pushpin.Name

objRecordset.MoveNext

Hope this gives you something to start with.

John

john@support-pc.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PC5, WPT, FUG, WAY, WP -> Mappoint Import	blottje	MapPoint 2006/2009 Discussion	8	09-16-2004 05:53 AM
Import Txt->MapPoint (VBA)	Anonymous	MapPoint 2006/2009 Discussion	0	04-22-2004 08:46 AM
Connection Time Out from "Post Reply Auto Email's Link&	JPeters	MapPoint 2006/2009 Discussion	2	08-05-2002 10:22 AM
Is Mappoint allows to import new map of my own and....	Anonymous	MapPoint 2006/2009 Discussion	1	12-23-2001 05:27 AM
When you embed the COM object into a form you auto....	Anonymous	MapPoint 2006/2009 Discussion	1	10-31-2001 07:04 AM

MapForums

Is it possible in MapPoint to import a set of Auto....

Is it possible in MapPoint to import a set of Auto....

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

Similar Threads