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
Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 37

MapPoint Power Tools Spreadsheet

This is a discussion on MapPoint Power Tools Spreadsheet within the MapForums Plus Downloads forums, part of the MapForums Plus category; What error do you get? I would recommend to go into the Program Files directory where the Microsoft MapPoint folder ...

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

    Re: MapPoint Power Tools Spreadsheet

    What error do you get?

    I would recommend to go into the Program Files directory where the Microsoft MapPoint folder is located and at the command prompt type

    > mappoint /regserver

    This sometimes solves problems when different versions of MapPoint have been installed on the computer.

    Do you have MapPoint North America or Europe?

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  2. #22
    jonesy is offline Junior Member White Belt
    Join Date
    Feb 2009
    Posts
    3

    Re: MapPoint Power Tools Spreadsheet

    Hi Eric,
    I have the 2009 North American Map Point version. I also have Excel 2007 and have tried runnng the ap as both a .xlsm and .xls version.

    I misstated in my previous thread. I am not actually getting an error message. I am not getting anything when I select the begin button. It is silent. I've been trying to use the distance zip code tab replacing the values in line 11 but nothing happens.

    From the command prompt window I have attempted to go to the map point directory and type in > mappoint /regserver as suggested in your previous thread. Although I do not believe this is the solution I have been unsuccessful in attempting this because I am either doing it wrong because it fails to recognize in the command prompt window this path. I am sorely inadequate in using DOS.

    I seem to be running out of options and really would like to be able to use this tool and wonder what else I can try.

    jonesy

  3. #23
    RonH is offline Junior Member White Belt
    Join Date
    Jan 2009
    Posts
    8

    Re: MapPoint Power Tools Spreadsheet

    Perhaps you are not getting to the correct directory. First, open your Windows Explorer and find the exact path to your Mappoint 2009 directly, most likely it is: C:\Program Files\Microsoft Mappoint 2009. But check, yours may be different.
    Then open the command prompt, found by going to Start-All Programs-Accesories-Command Prompt. When open type in (without the quotes) "cd c:\Program Files\Microsoft Mappoint 2009". (of course, use your path found above).
    When in that directory, type in the command mentioned above: > mappoint /regserver
    Hope this helps.

  4. #24
    jonesy is offline Junior Member White Belt
    Join Date
    Feb 2009
    Posts
    3

    Re: MapPoint Power Tools Spreadsheet

    Ron H
    Thank you. Correct. I had the wrong directory path and needed help on changing the directory. In addition I found that I had a setting in my version of excel preventing the maco from working. Once I corrected that and caught on to how the application works by changing values on line 11 that launched the map it all came together.

    jonesy

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

    Re: MapPoint Power Tools Spreadsheet

    Glad you got it working. Let me know if you have any suggestions for the spreadsheet. I'm hoping to release a new one in a month or two.
    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  6. #26
    flystol is offline Junior Member White Belt
    Join Date
    Apr 2009
    Posts
    4

    Re: MapPoint Power Tools Spreadsheet

    Hi Eric,
    I am a new forum member and lo level MapPoint user. I need to calculate aprox. mileage between zip codes for about 2 million records. I donwloaded your Excel tools but it appear the calculator only works on single records. Is there a way I can automate this function? Also, I am now using Excel 2007 - will your add-ins work with that newer version? Thanks for your help.

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

    Re: MapPoint Power Tools Spreadsheet

    It should work without any problem in Excel 2007. If you have a problem let me know, it would be a simple fix.

    2 million is a lot of records. It would take a really long time and I'm not sure Excel is going to handle lists that size.

    Do you need road distance or would straight line distance be sufficient? If straight line distance is OK, I could cook something up in Access...

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  8. #28
    flystol is offline Junior Member White Belt
    Join Date
    Apr 2009
    Posts
    4

    Re: MapPoint Power Tools Spreadsheet

    Eric,

    I only need straight line distance - does not have to be super accurate. An Access solution would be super.

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

    Re: MapPoint Power Tools Spreadsheet

    Can you send me a sample of your data and describe what you would like to do specifically?

    efrost@gmail.com

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  10. #30
    flystol is offline Junior Member White Belt
    Join Date
    Apr 2009
    Posts
    4

    Re: MapPoint Power Tools Spreadsheet

    Eric,

    Thanks for all your help on this solution. The Access macro works great - I was able to process my 1.5M records in less than an hour. I will provide you with a list of nice to have enhancements, but the basic functionality is there!

    Flystol

Page 3 of 4 FirstFirst 1234 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mapping from a spreadsheet
    By amandolin in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 06-09-2008, 12:16 PM
  2. screwedup spreadsheet
    By rgrstvr in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 01-11-2006, 04:12 PM
  3. Exporting mappoint map into power point
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 02-16-2004, 12:54 PM
  4. Different Pushpin Symbols from Spreadsheet
    By Terry in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-20-2003, 12:52 AM
  5. additional tools for MapPoint
    By Sebastian in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 01-24-2003, 02:41 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 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