MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




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


Go Back   MapPoint Forums > MapForums Plus > MapForums Plus Downloads

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-19-2008
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,471
Blog Entries: 1
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
File Type: gif geocode.gif (33.7 KB, 6 views)
File Type: gif distance.gif (8.5 KB, 3 views)
File Type: gif optimize_route.gif (12.6 KB, 5 views)
File Type: gif drivetime.gif (13.4 KB, 3 views)
Attached Files
File Type: zip MapPoint Power Tools_v1.2.zip (104.6 KB, 12 views)
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~

Last edited by Eric Frost; 08-21-2008 at 10:00 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 08-09-2008
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?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 08-11-2008
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,471
Blog Entries: 1
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
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 08-13-2008
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"
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 08-13-2008
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,471
Blog Entries: 1
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
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6 (permalink)  
Old 08-13-2008
Junior Member
White Belt
 
Join Date: Aug 2008
Posts: 3
Re: MapPoint Power Tools Spreadsheet

Thanks. 2006 Eric
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #7 (permalink)  
Old 08-13-2008
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #8 (permalink)  
Old 08-13-2008
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,471
Blog Entries: 1
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
File Type: zip MapPoint Power Tools_v1.2EU.zip (96.4 KB, 1 views)
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #9 (permalink)  
Old 08-13-2008
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,471
Blog Entries: 1
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
File Type: gif methodordatamembernotfound.gif (9.6 KB, 2 views)
Attached Files
File Type: zip MapPoint Power Tools_v1.2_for_2004NA.zip (98.4 KB, 8 views)
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #10 (permalink)  
Old 08-21-2008
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 2,471
Blog Entries: 1
Re: MapPoint Power Tools Spreadsheet

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

Eric
__________________
~ Now taking orders for MapPoint 2009 ~
~
~ Upgrade to MapForums Plus membership ~
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
automation, excel, mappoint, power, power tools, spreadsheet, tools


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Mapping from a spreadsheet amandolin MapPoint 2006/2009 Discussion 3 06-09-2008 01:16 PM
screwedup spreadsheet rgrstvr MapPoint 2006/2009 Discussion 3 01-11-2006 05:12 PM
Exporting mappoint map into power point Anonymous MapPoint 2006/2009 Discussion 6 02-16-2004 01:54 PM
Different Pushpin Symbols from Spreadsheet Terry MapPoint 2006/2009 Discussion 0 05-20-2003 01:52 AM
additional tools for MapPoint Sebastian MapPoint 2006/2009 Discussion 0 01-24-2003 03:41 AM


All times are GMT -5. The time now is 10:24 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map


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