MapPoint Forums

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 ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 08-24-2005
Junior Member
White Belt
 
Join Date: Aug 2005
Posts: 2
Send a message via AIM to TransportationNut05
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 08-24-2005
Winwaed's Avatar
Mapping-Tools.com
Red Belt
 
Join Date: Feb 2004
Posts: 787
Blog Entries: 5
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 08-24-2005
Junior Member
White Belt
 
Join Date: Aug 2005
Posts: 2
Send a message via AIM to TransportationNut05
Thanks for you help Richard!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Cheap Flights to Benidorm
Book cheap flights to Benidorm with Holiday Hypermarket. Whether Summer or Winter Benidorm is a great destination.

City Breaks
Top 10 City Breaks . Based on holidays booked this year, these are the most popular City Breaks for 2006

Cheap Holidays to Turkey
If you’re looking for cheap holidays to Turkey then dealchecker.co.uk is the place for you! Our search helps you see real prices from the UK’s top holiday companies all in one go.

Holidays in Dubai
Holidays in Dubai are an eclectic mix of the ancient and the modern. Discover an oasis of luxury amid the Arabian desert. Book here now!

Cheap Spain Holidays
Stay well informed when you are searching for cheap holidays online. For useful advice on when to book cheap Spain holidays make sure you look on ulookubook.com

Compare flight prices
Travel.co.uk makes it easy for you to compare flight prices from hundreds of UK based travel companies.

Holidays to Goa
Golden beaches, coconut trees. Visit On The Beach for holidays to Goa, and experience India!


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51