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

I am wondering if anyone has built a COM add-in ap....

This is a discussion on I am wondering if anyone has built a COM add-in ap.... within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am wondering if anyone has built a COM add-in application or has written VB code that will query two ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I am wondering if anyone has built a COM add-in application or has written VB code that will query two sets of data in MapPoint 2002 and determine whether the locations of dataset 1 (imported address info from excel) are within a given radius of dataset 2 (also imported address info from excel)

    Would like to eventually create a form that accepts the following inputs:
    DATASET 1: user may select a dataset already imported to the current MapPoint file
    DATASET 2 same operation as dataset 1
    RADIUS: the distance in miles from the data points within dataset 1 that will be used to find the data points within dataset 2.
    OUTPUT FILENAME: allows the user to specify the filename of a new excel file where the results of the query will be stored.

    I am guessing that the records from dataset 1 would have to be converted to lat/long in order to create the radius and capture the resulting pushpins from dataset 2?

    Appreciate any response that might help me address and solve this problem

    Regards,
    Jonathan Martin

  2. #2
    Walt Cygan is offline Senior Member Green Belt
    Join Date
    Aug 2002
    Posts
    124
    I don't know of anyone who has specifically done this, but it certainly can be done. The only question would be performance, which would mostly depend on the size of the datasets. If dataset 1 has x records and dataset 2 has y records, you'd have to do x*y calculations of distance.


    While lat/lon would be helpful for importing the data, it is not necessary. The Distance method will work using the Location objects of any 2 Pushpins. Check the programming help documentation. This assumes you want a crow's flight distance. If you want a driving distance, you will need to create a route by adding pushpins as waypoints, then calculating the route and reading the Distance property.


    - Walt Cygan

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Built-in Undo/Redo functionality?
    By Boelling in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-15-2004, 03:52 AM
  2. I was wondering if Mappoint 2002 had an API that I....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-22-2002, 01:58 PM
  3. I was wondering if there was any direct method to ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-13-2001, 06:29 AM
  4. Hello, I'm wondering if there is a way to include....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-04-2001, 11:52 AM
  5. My company was wondering what is the accuracy of y....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-11-2001, 12:30 PM

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