MapPoint is intended for business users but competes in the low-end geographic information system ("GIS") market. Numerous acquisitions (Vexcel, Vicinity Corporation, GeoTango, etc.) have supplemented both data and feature integration. The software and technology are designed to facilitate the geographical visualization and analysis of either included data or custom data. This is accomplished with the following code in the ThisWorkbook section of the Excel document.Microsoft MapPoint is a discontinued software program and service created by Microsoft that allows users to view, edit and integrate maps. When the Excel workbook Excel MapPoint Automation v1.xlsm is opened, it also opens the MapPoint PTM file Info.ptm in the background and leaves it open for use later. This is set to reference the table in =$A$2:$A$53. This is a drop-down created using Data | Data Validation | and then choosing to Allow: List. The sample app is not sophisticated by any means, but it serves its purpose to explain the code. Unzip the contents - two files Excel MapPoint Automation v1.xlsm and Info.ptm and place them in a folder. The purpose of this example application is fairly simple - show a map in Excel that is updated based on some action in Excel.įirst, DOWNLOAD THE SAMPLE APP HERE - Sample Excel MapPoint Application from MapForums Activate, but we'll leave this exploration for a future article or as follow-up below. I do think automation of an embedded MapPoint document is possible, I think we would just need to iterate and properly reference the object and.
Originally seeking to automate a MapPoint map embedded into Excel, we decided this would not be the ideal solution as the image that results in Excel and the embedded document is closed, often does not look good. This article came about in response to a request for help with MapPoint in the forum. In any case, that job (automating MapPoint) often falls to Excel's macro/VBA facility. This could be as simple as interpreted Python scripts, or the latest. MapPoint does not have it's own, built-in Table Viewer and Editor such as other mapping software like MapInfo Pro and ArcGIS.Īlso, MapPoint does not have it's own VBA scripting editor, thus necessitating anything else to make the COM calls.
To some degree, this is by necessity and design.
I would posit that more than 50% of the work done with MapPoint also involves Excel in some capacity. This articles shows a relatively simply way to control MapPoint and paste map images into Excel based on some event or changes in Excel, bringing powerful mapping capability into Microsoft Excel.
0 kommentar(er)
