MapForums

Developing with MapPoint and Excel - Getting Started

This thread refers to a mini-tutorial in the latest MP2Kmag Newsletter. Subscribe by sending an e-mail to newsletter-subscribe@mp2kmag.com.

"Excel is an easy to use black board or sandbox for playing with MapPoint automation/programming and in tandem with output from MapPoint can be a powerful platform for all sorts of geospatial analysis. Perhaps the hardest part for beginners is figuring out where to begin. In this example I will outline the steps involved in setting up a basic macro for launching MapPoint."

Read the mini-tutorial here:
http://www.mp2kmag.com/update/mappoi.../#features_sec

Click Post Reply to post a question or comment.

I am interested in seeing examples of controlling MapPoint through Excel, this promises to be an interesting topic.

I was recently had a set of maps that had been created that used text boxes as labels for multiple locations on each map. I wanted to use VB in Excel to select all text boxes on the map and set the border to 1 pt. I'd be curious to see how that is done. Thanks.

[quote=Eric Frost;8103]Developing with MapPoint and Excel - Getting Started

This thread refers to a mini-tutorial in the latest MP2Kmag Newsletter. Subscribe by sending an e-mail to newsletter-subscribe@mp2kmag.com.

"Excel is an easy to use black board or sandbox for playing with MapPoint automation/programming and in tandem with output from MapPoint can be a powerful platform for all sorts of geospatial analysis. Perhaps the hardest part for beginners is figuring out where to begin. In this example I will outline the steps involved in setting up a basic macro for launching MapPoint."

Read the mini-tutorial here:
What's New at MP2K Magazine - The Magazine for MapPoint

New starter

I have Mappiont 2004 Europe and I am trying to follow yout first tutorial but when running the Macro I have the message ActiveX component can't create object . I am sure it is due to the Set oApp line of the script.

Yes, change the NA in this line to EU

Set oApp = CreateObject("MapPoint.Application.NA.11")

Or better yet, try ommitting the entire .NA.11 part and just do this

Set oApp = CreateObject("MapPoint.Application")

hope this helps,
Eric

__________________

Hi Erick,
I have been following the tutorial to work out how to do the programing.
I cant select Microsoft Mappoint11.0 Object... I only have the 13.0 version. I have selected this, but cant get the button to work.
any ideas?
Tom

Do you want to post your spreadsheet here as an attachment? I will take a look. What version of Excel and MapPoint do you have (NA or EU) ?

Eric

__________________

Hi Eric,

I have been playing with this problem only for a weekend, but your code seems to work beautifully, after editing for my current version of MapPoint.

However, I was wondering if there was a way to automate the closing of MapPoint after the code has ran, without saving the map of course. Then I can set the Visible to false and make it look automagical.

Thanks in advance.

Actually if you just put the oApp statement inside the Sub then it will go out of scope and close... this would be one way to do it.


Eric

__________________

That works, MapPoint closes, but it still asks to save the map. I am a non-programmer and am not sure how to work around this.

Just put in there a statement objMap.Saved = True..

You also need a objMap object. All the code would look like:

Eric

__________________