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.

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?

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

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"

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

Thanks. 2006 Eric

Originally Posted by Eric Frost

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.

Originally Posted by PhilUK

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

Originally Posted by DBWalk

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.

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

Eric