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 2 of 2

Beginner looking for help with MapPoint/Excel project

This is a discussion on Beginner looking for help with MapPoint/Excel project within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am putting together a spreadsheet in excel that I will be plugging an address into (# Street, City, State...all ...

  1. #1
    mlmcvinney is offline Junior Member White Belt
    Join Date
    Feb 2012
    Posts
    1

    Question Beginner looking for help with MapPoint/Excel project

    I am putting together a spreadsheet in excel that I will be plugging an address into (# Street, City, State...all in different cells) and I want it to then automatically fill in the zip and latitude/longitude cells. I have excel 2007 and MapPoint 2011 and have never done this before...the "A,B,C's" would be very helpfull! lol Do I need to download any other programs onto my computer?

    Thank you very much for any help that anyone can offer!

    Mike

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Beginner looking for help with MapPoint/Excel project

    Take a look in the MapForums Downloads section ($99), in particular the MapPoint Power Tools spreadsheet Geocoding tab. This includes Excel VBA source code and could be modified to get zip code. Of course geocoding is sometimes a crap shoot, thus the fields to show Quality and to what Geography it was matched.

    I've been thinking about another tool using the ObjectsFromPoint function to show what City/State/Zip Code, etc. a point is in, but that could certainly be combined into one tool as you are requesting.

    Anyway, take a look and then let me know your thoughts about next steps, if you would like to talk later today or tomorrow I think we could wrap it up in just a one or two hour training/consulting session.

    Eric
    m: 312-399-1586
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 12-26-2011, 06:21 AM
  2. 2006 VBA Project References in Excel
    By onegalacticwino in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-20-2006, 10:45 PM
  3. Using MapPoint to chart soil types <>Beginner<>
    By jhblack76 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-08-2004, 05:39 PM
  4. Help a beginner incorporate mappoint into website
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-17-2003, 12:35 AM
  5. Beginner in need of help...
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-15-2003, 07:08 PM

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 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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127