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 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 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; I have just downloaded the MapPoint Power Tools_v1[1].2.zip. I would like to know whether this version will work on MapPoint ...

  1. #11
    garyclin57 is offline Junior Member White Belt
    Join Date
    Aug 2008
    Posts
    1

    Re: MapPoint Power Tools Spreadsheet

    I have just downloaded the MapPoint Power Tools_v1[1].2.zip. I would like to know whether this version will work on MapPoint 2009. Thanks.

    Gary Lin

  2. #12
    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

    Yes, it should.. have you tried it and did you get any error? Let me know and I'd be happy to fix it.. if there is an error it should be an easy fix.
    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

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

    Re: MapPoint Power Tools Spreadsheet

    Similar to the post above, I just purchased MapPoint 2009. I had been using the Power Tools spreadsheet with MapPoint 2002 without a problem, but after un-installing MP2002 and installing MP2009, I get an error.
    The error says "Run-Time error '429' - ActiveX component can't create object"

    When I debug the program is stopped at this line:
    Set oApp = CreateObject("MapPoint.Application.NA")

    The Microsoft MapPoint 16.0 Object Library (North America) reference is checked in the Tools-References dialog.

    MapPoint 2009 runs fine by itself. Can you assist me?

    Thanks,
    Ron

  4. #14
    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

    Here's two things to try..

    Using a command prompt, go to
    C:\Program Files\Microsoft MapPoint 2009\
    and type
    > mappoint /regserver

    Now, try the attached spreadsheet, I explicitly reference MapPoint 2009. I don't think this would be necessary, but I tested this spreadsheet after running mappoint /regserver and it worked.

    Let me know how it goes!

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

  5. #15
    RonH is offline Junior Member White Belt
    Join Date
    Jan 2009
    Posts
    8

    Re: MapPoint Power Tools Spreadsheet

    Thanks, Eric, but it didn't work. It must be a problem with my laptop, as I installed MP 2009 on my desktop machine (after removing MP 2006), and everything works OK, even with the normal version of the Power Tools Spreadsheet.

    I tried an uninstall and then a re-install of MP 2009, and then I did the mappoint /regserver command in the command prompt. Still didn't work. The same error as before comes up. For some reason, my laptop system refuses to recognize the mappoint object library or the mappoint activex control. I tried both in the Tools-Reference dialog, not at the same time.

    Is there supposed to be some type of response with the mappoint /regserver command? After hitting enter, there is no comment on the action taken, the c:\Program Files\Microsoft Mappoint 2009 directory prompt just appears.

    Thanks for your help. I know it is very frustrating to troubleshoot long distance. I have a copy of Mappoint 2006, I wonder if I removed 2009, installed 2006, removed 2006, then reinstalled 2009 if it would work?
    My laptop had an old version of MP 2002 originally installed, so maybe MP 2006 leaves some files needed?

  6. #16
    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

    mappoint /regserver is supposed to clean up cases where there are multiple versions installed (or old versions were installed previously) and force the exectuable you are running it with to be the "current" version. There is no response, it is silent.

    Your suggested course of action doesn't sound to me like the solution, but it couldn't hurt!

    I am wondering if it is something with the Excel/Office versions? What version of Excel is on each? Do you have admin rights on both machines? Anything else that could be different between the machines?

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

  7. #17
    RonH is offline Junior Member White Belt
    Join Date
    Jan 2009
    Posts
    8

    Re: MapPoint Power Tools Spreadsheet

    Fixed it!!! I found it under an old posting to this forum at http://www.mapforums.com/sitemap/t-5256.html

    ================

    "We experienced the same problem with some users who had been running an earlier version of MapPoint (2002 or 2004) on their PC, and then installed MapPoint 2006. After spending some time with Microsoft techs, the problem was discovered to be permissions-related. The solution was as follows:

    1. Using RegEdit, change the permissions on HKEY_CLASSES_ROOT\.ptm and HKEY_CLASSES_ROOT\.ptt to Full Access for the Administrator. (to do this, right-click on the .ptm folder under HKEY_CLASSES_ROOT and select "permissions")

    2. From command prompt, reregistered MapPoint using the command "C:\Program Files\Microsoft MapPoint\MapPoint.exe" /regserver.

    The Microsoft tech said that he has seen this more than a few times with users running MP2006 who had previously been running an earlier version. He says that they are checking to see if this is, in fact, a bug with the MP2006 install routine. Good luck!"

    =======================

    I uninstalled MP 2009, then removed an old registry value to Mappoint.exe, then re-installed MP 2009. Using the above suggestion, I went into the registry and sure enough, the .ptm and .ptt did not have full permissions set. I set them to full access. I then ran the /regserver just to be sure and everything works great now.

    Thanks for your quick replies. You set me on the right track.

    Ron

  8. #18
    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

    "He says that they are checking to see if this is, in fact, a bug with the MP2006 install routine."

    I guess they never figured it out since you are having trouble with MapPoint 2009!

    Anyway, glad to hear you have solved and it maybe I should delete the "_2009" version so as not to confuse people. I assume you can use the original one OK?

    I want to create a new version 2.0 with some new tools to be released in the next month or two. Do you have any suggestions on functions to include or stuff that would be useful to have?

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

  9. #19
    RonH is offline Junior Member White Belt
    Join Date
    Jan 2009
    Posts
    8

    Re: MapPoint Power Tools Spreadsheet

    Yes, the original version of the Power Tools spreadsheet works fine now.

    I am glad you are thinking of updating it, because I do have a suggestion. Could you add the capability of using latitude and longitude numbers for point locations as well as normal street addresses? I could use this for all the routines. You see, our company uses lats and longs for our delivery locations because of the inherent unreliability of street addresses due to new roads, misspellings, etc. of which I know you are aware. Any lat/long format would do, but for simplicity we use decimal degrees, i.e.; -78.36, 37.45

    I purchased the excellent add-in Routene found on this site from Tamarack, and the developer has graciously made it able to read lats and longs for me. It is a great help and makes the add-in extremely useful for me.

    If I can think of other suggestions, I will forward them to you via this forum. I will be working with the Power Tools extensively on several projects I am considering for my company.

    Thanks again,
    Ron

  10. #20
    jonesy is offline Junior Member White Belt
    Join Date
    Feb 2009
    Posts
    3

    Re: MapPoint Power Tools Spreadsheet

    Eric,
    I've tried to get the MapPoint Power Tools Spreadsheet working on my client but to no avail. I've read through the following thread and even changed the ptm and ptt hotkeys to allow administrator full use privileges thinking this may be the constraint as I had a previous (trial) version of mappoint some time ago that has since been deleted.

    I spreadsheet is not functioning. I recently installed MP2009 and would truly like to use the spreadsheet tools but at this point i am stumped. In addition I am not advanced programming capable. Please advise.
    Thanks
    Jonesy - new user

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