MapForums
Community of VE/MapPoint Users and Developers
setting up macro in excel to extract lat/long from map point
This is a discussion on setting up macro in excel to extract lat/long from map point within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hello! I am relatively new to map point 2004. This forum has a wealth of information. I was wondering if ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
08-24-2005
| |||
| |||
| setting up macro in excel to extract lat/long from map point Can any one show me the light? Thanks          |
|
08-24-2005
| ||||
| ||||
|
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
__________________ Winwaed Software Technology LLC http://www.winwaed.com See http://www.mapping-tools.com for MapPoint Tools Pre-Order MapPoint 2009 today: http://www.mapping-tools.com/mappoint2009 |
|
08-24-2005
| |||
| |||
|
Thanks for you help Richard! |
 |
« Addresses not found for MapPoint 'isMached'!
|
What's the order criterion without the optimization of the s »
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Locate City and zip code using lat and long (Excel Macro) | sberhe | Wish List | 0 | 04-01-2005 09:31 AM |
| How do I extract city list to excel? | Anonymous | MapPoint 2006/2009 Discussion | 0 | 03-15-2005 10:02 AM |
| Extract Lat/Long by Zip Code | Anonymous | MapPoint 2006/2009 Discussion | 2 | 11-25-2004 06:52 AM |
| Using a macro to get a map into excel | jimbob | MapPoint 2006/2009 Discussion | 2 | 03-29-2004 05:21 AM |
| updatelink using macro in Excel XP | amyles | MapPoint 2006/2009 Discussion | 0 | 07-17-2003 01:26 AM |
All times are GMT -5. The time now is 04:57 PM.
