Click here to view this issue online Click here!

Friday - January 11, 2013
Mapping Goals for 2013, Developing the MapPoint State Identification Game
MapPoint 2013Welcome to another issue of the MP2Kmag Update. A belated Happy New Year! Hope you are having success with your New Year's Resolutions and reaping the benefits.

In this issue we ask you to share your mapping goals for 2013 and would like to hear how we here at MP2Kmag and the community at might be help you acheive your goals.

Also, there are two new articles on how the State Identification Game was set up and developed. The game was first released in the last newsletter, but this is the first time the complete, uncompiled code has been made available. Although a fun challenge in and of itself, the solution demonstrates a simple but powerful framework to automate MapPoint from Excel using a custom form.

MP2K Magazine is your source for independent news and information about MapPoint and other Microsoft mapping technologies and we also host the popular web forum for MapPoint users and developers (

This Issue's Contents at a Glance
- Recent Forum Highlights
- What are your Mapping Goals for 2013?
- TIP: Use Map Settings to Clean Up Your Map
- Get Published in MP2K Magazine
- Setting Up the State Identification Game
- Developing the State Identification Game

Happy Mapping and please forward this newsletter to anyone who would be interested!

Eric Frost, Editor
Buy MapPoint 2013 North America or Europe - $249
Includes One Year Access to MapForums Downloads - $99 Value Free!

Buy MapPoint 2013 with all new updated roads - the North American version has 150,000 miles of new roads compared to MapPoint 2011!

Microsoft MapPoint 2013 European maps provides detailed street-level maps and address-search capability for Austria, Belgium, Denmark, Finland, France, Germany, Greece, Italy, Luxembourg, Netherlands, Norway, Portugal, Spain, Sweden, Switzerland and the United Kingdom. In addition, MapPoint European edition provide some street-level coverage, but does not support address find, for Andorra, Bosnia and Herzegovina, Bulgaria, Croatia, Czech Republic, Estonia, Gibraltar, Guernsey, Hungary, Ireland, Isle of Man, Jersey, Latvia, Liechtenstein, Lithuania, Monaco, Montenegro, Poland, Romania, San Marino, Serbia, Slovakia, Slovenia and the Vatican City. More details.

Each license will also include a free one year access pass to the downloads section on MapForums, the MapPoint and other Microsoft mapping products discussion forum - $99 value.

Free 2nd FedEx Delivery within United States (option to upgrade to overnight shipping), $35 FedEx Priority shipping to Canada, and $75 FedEx Priority for other international orders.

See our recently updated MapForums store to order including payment processing options for both Plimus and Paypal. Volume discounts available.

Update your MapPoint maps to the latest digital map databases!


MapPoint 2013

Recent Forum Highlights

Here are some higlights from MapForums over the last couple months. MapForums is an active community of MapPoint and other mapping software developers and users. If you are a heavy or even occasional user of MapPoint and other mapping software, it would be worth your time to Introduce Yourself and post your nagging questions, share solutions, and get connected with others in your industry or using MapPoint in similar ways.
Have a MapPoint Question or have Mapping or Technology News to share? Register for free and then post in the appropriate forum section:

MapPoint Desktop, Bing Maps, Articles, News & Announcements, MapPoint Consultants & Companies, MapPoint Add-ins, General Chat & Introductions, MapForums Downloads, MapForums Store

What are your Mapping Goals for 2013?

Diet and exercise are among the most common New Year's resolutions, but setting business and career goals are certainly up there. As most of our readers would probably agree, use of business mapping technologies like MapPoint can be a big part of that.

Given that, what do you want to accomplish with MapPoint or mapping in the next year? Use of smarter macros, new custom symbols or figuring out better ways to depict data, training for yourself or co-workers or your employees, use of algorithms for clustering or territory assignment? Post here or drop us a e-mail at

TIP: Use Map Settings to Clean Up Your Map

The purpose of this TIP is to show how you can get this map, with the default map style and setting...

Default MapPoint Map

to look like this less cluttered map...

MapPoint Map Settings

Instructions and more details are found in the Tips & Tricks section on

Large MapPoint MugGet Published in MP2K Magazine

If you have a MapPoint presentation, neat programming technique, or would simply like to share the ways in which you are using MapPoint technology or any other ideas, contact us to discuss how we can turn your knowledge into an article and share your experience with the rest of the MapPoint community of users and developers.

Thanks to Marvin Hlavac for allowing us to use the picture on the right of his Maltese puppy eating from the MapPoint mug.
Click here!


State Identification Game Setting up the State Identification Game

This article demonstrates a couple preliminary steps involved in setting up the State Identification Game.

"The "State Identification Game" was released in 2012 and has gotten a lot of attention from both gamers and developers.

"The concept is the game is very simple. The game shows the outline of a random U.S. state and asks you to identify the state. The outline of the state and surrounding states as well as water bodies (major lakes and oceans) can all be used as clues to identify the state. It sounds simple, but I did in fact miss a few before practicing a little bit.

"The compiled game can be downloaded here -- State Identification Game Using MapPoint

"In this article, we will publish the code used to set up the game as well as the code for the game itself."

More Full article text Discuss Discuss this story
Developing the State Identification Game

The complete code and uncompiled .xlsm file are available for download. Post any questions about the code or how it might be adapted to your projects in the discussion area below the article.

"Since the publication and release of the game in late 2012, the State Identification Game quickly became the most popular download of all time on MapForums.

"The State Identification Game was developed using Excel VBA and MapPoint. The MapPoint version must be at least 2010 as it was in this version that you were first able to manipulate map layers and turn off labels. Excel versions tested include 2007 and 2010, but I don't see a reason why it should not work with earlier versions of Excel.

"Since the released of the compiled game, several developers have asked, and I have previously shared the code privately, but now for the first time in this article, we are now making the full source code for the game available for public download."

More Full article text Discuss Discuss this story

MapForums Downloads Section

Get access to dozens of tools for automating MapPoint and performing advanced tasks.

Geocode Addresses
Optimize a Route
Distances Between Zip Codes

Drawing Circles Around a List of Lat/Lons
Extracting Coordinates of a Route
Import a Route with Stoptimes and Depart Times
Calculating Route and Straight Line Distances Between Lat/Lon Coordinates
Drawing Lines from Coordinates in Excel
Drawing Lines Between City/State Pairs
Straight Line Distance Between Zip Codes
How To: Mapki Icon Image sets
Drawing Drivetime Zones Around Lat/Lon's
Export "Places" from MapPoint to MS Access
Worldwide Airport Database
Generate a List of Points of Interest
Drawing Radii (Circles)
Map With County Lines
Map of US 48 States Only
ALSO: 10% Discount on Mapping-Tools Products
COMING: Census 2010 Data in MapPoint!
Full source code included. Macros can be freely modified and incorporated into your own systems. Tools do not expire.

Upgrade now and get immediate access to all the tools listed above as well as updates and new tools posted in the coming year.

Upgrade your MapForums account and upgrade your MapPoint Experience!

Look forward to upcoming issues in which we focus on recent MapPoint and Bing Maps news and share forum highlights.

Previous issues of the MP2Kmag Update are available in the newsletter archive.

Copyright 1999-2013 MP2K Magazine

To subscribe to this newsletter and ensure you receive future issues on your preferred e-mail address, or unsubscribe use the form at
Please forward this newsletter to anyone who would be interested!