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