I am programming an Excel add-in for MapPoint 2002, and have come across a small problem. My application will plot the nearest points between two datasets (as in nearest warehouse for N customers), and exports the whole thing to an Excel sheet.
When I import address files into MapPoint, I usually have some locations it can't match automatically, and it asks to pick one from a list of choices. It plots a pushpin in the selected location and all is well. When I export the information (all data associated with the pushpin), it exports the original, non-matching addresses.
That's sometimes useful, but in general I will be putting the data back through MapPoint to create different maps. I run into the same problem as the original match, some locations don't match automatically.
I need to find a way to export the actual pushpin location, to export what MapPoint matched my address to and not necessarily the original address.
I can use Lat/Lon code to do it, but I want the actual address/location. Any ideas?