PDA

View Full Version : Zoom To Location Question: Excel Embedded Map



jake.masters
10-09-2012, 12:04 PM
Hi everyone,

I have a (maybe) quick question about the versatility of Mappoint. I am an average enough user of VBA in excel, access, etc to usually get what I want, but I have not yet learned Mapppoint and its capabilities. I just purchased it yesterday.

Essentially, what I would like to do is embed a proloaded map (in Mappoint 2013) into an Excel 2010 spreadsheet. When the user changes a certain cell's value, the map zooms to that cell's corresponding pushpoint.

I have read up somewhat, and I believe I can use the ZoomTo function to achieve my goal, but I do not know how to link my destination address to Excel information.

For example, if the user selects a drop down of NewYork, I could do a lookup of the lat/long stored in the excel spreadsheet, send this to mappoint, and snap to the location.

Is this possible? And if so, are there any tips you guys could give me to help out?

Thanks!

Eric Frost
10-09-2012, 01:37 PM
I don't know how well an "embedded" map would work, but I think what you want to achieve can certainly be done.

I would probably open a hidden instance of MapPoint in the background, and then whenever the value is updated, update your hidden map in the background and then copy it to Excel as an image.

There would be some extra error checking first to
-- check if MapPoint is installed and inform the user if it is not.
-- also, before updating the map, make sure the hidden instance of MapPoint is still open, otherwise open it.
-- also maybe some extra code to kill any orphan instances of MapPoint or cleanup when the workbook is closed.

I could help you with this if you like, maybe a 1-2 hour training session to whip up the code?

Eric

Eric Frost
11-08-2012, 04:58 PM
Just want to follow up --

This ended up being developed as an article and featured in our most recent newsletter:
MapPoint 2013 North America, MapPoint 2013 Europe, MapPoint & Excel Dashboard, MapPoint Game (http://www.mp2kmag.com/update/mappoint.newsletter/2012-11-01/)

Here's a direct link to the article including a screenshot of Jake's awesome Excel app which uses this:
http://www.mapforums.com/sample-excel-application-automating-mappoint-pasting-map-images-into-excel-part-1-2-a-20990.html

We will be posting a follow up article in the coming weeks which will add some error checking and refinements, let me know if you would like to see anything in particular.

Eric