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 1 of 4 123 ... LastLast
Results 1 to 10 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; The MapPoint Power Tools spreadsheet has several tools which are separate tabs or worksheets. Geocode Addresses Optimize Route Initialization Mapping ...

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

    MapPoint Power Tools Spreadsheet

    The MapPoint Power Tools spreadsheet has several tools which are separate tabs or worksheets.

    • Geocode Addresses
    • Optimize Route
    • Initialization
    • Mapping An Address
    • Distance Between Zip Codes
    • Drawing Drivetime Zones


    Each of these includes full source code and can be customized... it basically shatters the kludgy MapPoint interface for doing things and shows you how to automate or program the MapPoint functions from lists and values in Excel.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Eric Frost; 08-21-2008 at 09:00 AM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  2. #2
    PhilUK is offline Junior Member White Belt
    Join Date
    Aug 2008
    Posts
    3

    Re: MapPoint Power Tools Spreadsheet

    Eric. For someone who knows the basics of MapPoint... but only that...how do I use the optimization tab with my own data. Also as I am in the UK I use the European map version...is this a problem?

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

    Hi Phil,

    You just need to replace the sample addresses that are in there with your own list of addresses and click the button.

    Let me know if you have any trouble and I can set up a LiveMeeting session to demo it.

    The spreadsheet is fully compatitible with the European version.

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

  4. #4
    PhilUK is offline Junior Member White Belt
    Join Date
    Aug 2008
    Posts
    3

    Re: MapPoint Power Tools Spreadsheet

    Eric

    Thanks for the response

    I know I am probably being thick over this but when I open the spreadsheet on any tab and I even put the cursor near the button, let alone click it, I get a Visual Basic error message "Compile error. Can't find project or library"

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

    No, I'm sure it's something I need to fix. What version of MapPoint Europe do you have installed? 2004 or 2006? I'll set up a test environment and check it out.

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

  6. #6
    PhilUK is offline Junior Member White Belt
    Join Date
    Aug 2008
    Posts
    3

    Re: MapPoint Power Tools Spreadsheet

    Thanks. 2006 Eric

  7. #7
    DBWalk is offline Junior Member White Belt
    Join Date
    Aug 2008
    Posts
    1

    Re: MapPoint Power Tools Spreadsheet

    Quote Originally Posted by Eric Frost View Post
    No, I'm sure it's something I need to fix. What version of MapPoint Europe do you have installed? 2004 or 2006? I'll set up a test environment and check it out.

    Eric
    I am getting the same error message trying to use the tool with an older version (2004). Can't figure out how to link the right objects.

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

    Quote Originally Posted by PhilUK View Post
    Thanks. 2006 Eric
    Try this one for the European version.. the code WAS explicitly trying to load the .NA version, so this should fix it. Let me know if it works and I'll go ahead and replace the version posted at the top of this thread.

    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 ~

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

    Quote Originally Posted by DBWalk View Post
    I am getting the same error message trying to use the tool with an older version (2004). Can't figure out how to link the right objects.
    I directly reference the 2004 (NA) version with the attached spreadsheet, I tested it and it works.

    Note that the Geocode address will not work because I use the .Latitude and .Longitude properties that were added in MapPoint 2006... let me know if you need this and I can substitute those properties with Gilles Kohl's hack.
    Attached Images Attached Images
    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 ~

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

    I added several screenshots to show some of the functions..

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

Page 1 of 4 123 ... 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 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