MapForums

I've imported a data set as a set of pins based on addresses. I've then used the "Find Nearby Places" to show all points within a 25km radius of a point of interest.

On my data sets down the left hand side, I can see it's picked out each of these points individually, and given a "distance". What I'd like to do now is simply export these points, along with the distance, to excel.

I can't find a way of doing this! The only thing that seems to work is to manually draw a radius to match by eye.

There must be an easier, and more precise, way?

Any help most appreciated

(Mappoint 2004 Europe)

Anyone?

How about instead (if it's easier) - a list of postcodes in a single Excel column, a single reference postcode in a separate cell, then a macro that compares the reference to each postcode and enters a distance between each in the adjacent column

eg.

Ref: WA22 2RS

RM22 2QR 396km
N4 3QR 384km

etc.

You will need a little bit of programming to automate the process you've tried by hand: Find the location of the new postcode. Measure the distance from the reference location to the new location. Save that value.

Or if you pre-load your data into MapPoint as pushpins, you could use my MileCharter product to do this (see links below). As well as straight line distances, this would also be able to find route distances amongst other things.



Richard

__________________
Winwaed Software Technology LLC
http://www.winwaed.com
See http://www.mapping-tools.com for MapPoint Tools
See the Geoweb Guru for online mapping