setting up macro in excel to extract lat/long from map point

Hello! I am relatively new to map point 2004. This forum has a wealth of information. I was wondering if any of the experts in here could help me out. I am trying to create a macro that will take addresses I have in an excel spreadsheet and insert their lat/long.

Can any one show me the light? Thanks :D

If you upto doing some programming, then you can do this by finding a Location object for each address. Then use the Gilles' CalcPos routine (search the articles on this site) to find the longitude and latitude of the Location object.

Or you could use John Meyer's Pushpin Tool. This is an addin and costs $75.
You will need to import your address data using MapPoint's Data Import Wizard to create a series of pushpins. Then use the Pushpin Tool to export them to Excel. The tool can be obtained from this site or mine, and there's a free (time-limited) demo.


Richard

Thanks for you help Richard!