none
COM add-in to MapPoint to display only filtered data from Excel datasheet source RRS feed

  • Question

  • I am working on creating MapPoint maps by linking them to Excel tables. These tables contain a lot of data which makes the maps I created cluttered and not easy to visualize information on. To solve the issue, I'm thinking about using a slicer to make the Excel tables display only part of the rows at a time and have the maps only display the data selected with the help of the slicer. I believe that it could be possible to do that by adding a COM add-in to MapPoint and writing code to tell MapPoint to only display on the map the data filtered in the Excel table using the slicer. Has anyone tried that, and if yes how can this be done? I don't really have programming skills so if that is possible, the next thing would be to help me write a code to get MapPoint to do that....Please let me know if that's completely far-fetched as it's just a crazy idea that I had to try to solve my problem. FYI, I'm using MapPoint 2011 North America and Excel 2010.

    Saturday, November 14, 2015 4:47 PM

Answers

  • MapPoint was discontinued last year as noted here: https://www.microsoft.com/mappoint/en-us/home.aspx There will be no new versions. It's not recommended to do any new development with MapPoint. Also, if you are using the 2011 version there is a lot of old data in there. There are also a lot of better options.

    Since you are working with an Excel file, there are several good options. If you upgrade to Office 2013, 2016 or 365 ProPlus you will have access to Power Maps which is a powerful mapping tool that is built into Excel that can render millions of locations on a map with little effort. If you want to stay on Excel 2010 I recommend taking a look at Excel add-in from MapCite: http://www.mapcite.com/excel-addin.aspx It provides a lot of mapping functionality that works from Excel 2007 and above.

     

    http://rbrundritt.wordpress.com

    Monday, November 16, 2015 6:05 PM