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 2 of 2

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

This is a discussion on Is it possible in MapPoint to import a set of Auto.... within the MapPoint Desktop Discussion forums, part of the Map Forums category; Is it possible in MapPoint to import a set of AutoRoute push pins and then to export (to Excel) the ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    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?

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    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 Information

Users Browsing this Thread

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

Similar Threads

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

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 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83