Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

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

  1. #1
    TransportationNut05 is offline Junior Member White Belt
    Join Date
    Aug 2005
    Posts
    2

    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

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    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

  3. #3
    TransportationNut05 is offline Junior Member White Belt
    Join Date
    Aug 2005
    Posts
    2
    Thanks for you help Richard!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using a macro to get a map into excel
    By jimbob in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 03-19-2009, 05:21 PM
  2. Replies: 0
    Last Post: 04-01-2005, 10:31 AM
  3. How do I extract city list to excel?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-15-2005, 11:02 AM
  4. Extract Lat/Long by Zip Code
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 11-25-2004, 07:52 AM
  5. updatelink using macro in Excel XP
    By amyles in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-17-2003, 02:26 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


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