spacer1
spacer2 1_1 1_2
2_1
 Subscribe
 The MP2K Update!
 
 
 
 Magazine
Front Cover
What's New
Articles
News
Sample Data
Gallery
Advertise
About
 Features
MapPoint 2013
Press Releases
MapPoint Forums
Companies
Link to MP2Kmag
Wish List
MapPoint Trial
Authors
 Earlier Content
Past News Items
Past What's New Announcements
 Sponsors
 Order

MapPoint 2013

Programming MapPoint in .NET

MapPoint Book

  Spatial Community
SVG Tutorials
MapPoint

Map Visitors

  ARTICLES  


Using MapPoint from Word, Access and Excel

This article contains code snippets that allows you to seamlessly drop a map graphic into your Word, Access or Excel documents anywhere you have a valid address.

Using MapPoint From Word

MapPoint can be used from within Word. This code snippet allows you to seamlessly drop a map graphic into your Word documents anywhere you have a valid address. There is no reason to open MapPoint manually, enter the address, geocode it, copy the map to the clipboard, and then paste it into Word. This snippet does all that for you with a single mouse click.

1) Create a Macro in Normal.dot with this code:

2) Add the CreateMap Macro to your toolbar by right clicking on any toolbar and selecting customize.

3) Type a fully qualified address and click the macro.

"6531 Chesterbrook Drive, Sacramento, CA" works fine
		"6531 Chesterbrook Drive" does not work
"300 Indiana Avenue NW, Washington, DC" works great
"300 Indiana Avenue NW" does not because there are two. (MI and DC)

4) When you click the macro button on the toolbar, Word will contact MapPoint. MapPoint will then proceed to find the point and copy the map directly into your Word document.

Using MapPoint from Access forms

(MapDemo.mdb)

Microsoft Access can display MapPoint maps just like Word can. The macro is very similar to that of Word. Here, we have a form that can capture address information into a table. We can use that address information to generate a map as well as driving directions. (NOTE: For this demonstration, you can either create a database from scratch or use the accompanying MapDemo.mdb)

1) Create a form with Address information:
a. Fields for First Address: (Address, City, State)
b. Fields for Second Address: (Address2, City2, State2)
c. Field for Address Name: myName
d. Empty OLE Image (imgClip)
e. Command Button (cmdMap)

2) Add this code:

Using MapPoint from Excel

(MapDemo.xls)

We will use the same manner in which Microsoft Access accessed MapPoint and created a map in Excel. Excel will store the picture of the map right on our spreadsheet. In this example, we create a command button to launch MapPoint in the background and paste a copy of the map to the spreadsheet.

1) Add a command button to your spreadsheet.
2) Copy and paste the following code to your new command button's click event:

3) Save the spreadsheet!
4) On the B column, enter the address.
5) On the C column, enter the city
6) On the D column, enter the state
7) On the E column, enter the zip
8) Press the Command Button

Discuss this story in the forum.

Author: Christopher Gebhardt
Email: Chris(AT)CrimeAnalysis.net
URL: http://www.crimeanalysis.net
Chris Gebhardt is the Director of Marketing for CRISNet (www.crisnet.com) in Salt Lake City, Utah. He is also the CEO of Crime Analysis Associates (www.CrimeAnalysis.net) where he uses Microsoft products and specifically MapPoint in the creation of his Crime Analysis software.

Chris is a former Lieutenant with the Metropolitan Police Department in Washington, D.C. where he was the Commander of the Tactical Crime Analysis Unit responsible for crime analysis and crime mapping. This job is the basis for the TV show "The District."

In his spare time, Chris is the Technical Advisor to the California Crime and Intelligence Analysts Association (www.CrimeAnalyst.org).

Chris can be reached at chris@crimeanalysis.net.



Google
 
MP2Kmag Internet


 Recent Discussion
-Scania XCom v2.30
-SCADE Suite R15
-RISA Connection v8.0.1
-RISA 3D v16.0.3
-RipCente
-Riegl RiSCAN Pro v2.0 64bit
-RES2DINV v3.57
-zemax v2017
-Remcom XGtd v2.5.16
-worknc dental v5.0
-Remcom XFdtd v7.3.2.5 x64
-worknc dental v4.13
-Remcom Wireless InSite v3.2.0.3
-wonderware intouch v2014 R2sp1
-Remcom Rotman Lens Designer v1.7
-Zuken CADSTAR v16.0
-Reliasoft v10.0
-Zirkonzahn v2017
-REFPROP v9.0
-Zirkonzahn modellier v1.0
-Redshift v2.0 x64
-ZirkonZahn exocad v1.0
-RationalDMIS v5.5
-Zenon v6.22
-Radimpex tower7 v7.5.20
 Resources
Browse GIS books and periodicals
Find a MapPoint Partner or Consultant
Real Estate Columbia For Sale By Owner


Want Your Site To Appear Here?

   © 1999-2012 MP2K. Questions and comments to: website@mp2kmag.com
  Microsoft and MapPoint 2002/2004/2006/2009/2010/2011/2013 are either trademarks or registered trademarks of Microsoft.