Developing with MapPoint and Excel - Getting Started

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/mappoint.newsletter/2004-09-30/#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 (http://www.mp2kmag.com/update/mappoint.newsletter/2004-09-30/#features_sec)

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