Community of MapPoint and Virtual Earth Users and Developers
This is a discussion on Developing with MapPoint and Excel - Getting Started within the MP2K Magazine Articles forums, part of the Map Forums category; Developing with MapPoint and Excel - Getting Started This thread refers to a mini-tutorial in the latest MP2Kmag Newsletter. Subscribe ...
| |||||||
| Today's Posts | Twitter Feed | Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. |
| |||
| Selecting text boxes
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. |
| |||
| Re: Developing with MapPoint and Excel - Getting Started
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 |
| |||
| Re: Developing with MapPoint and Excel - Getting Started
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. |
| ||||
| Re: Developing with MapPoint and Excel - Getting Started
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. Code: Private Sub CommandButton1_Click()
Dim oApp As MapPoint.Application
Set oApp = CreateObject("MapPoint.Application.NA.11")
oApp.Visible = True
End Sub
__________________ |
| ||||
| Re: Developing with MapPoint and Excel - Getting Started
Just put in there a statement objMap.Saved = True.. You also need a objMap object. All the code would look like: Code: Private Sub CommandButton1_Click()
Dim oApp As MapPoint.Application
Dim objMap As MapPoint.Map
Set oApp = CreateObject("MapPoint.Application.NA.11")
oApp.Visible = True
Set objMap = objApp.ActiveMap
objMap.Saved = True
End Sub
__________________ |
![]() |
| Tags |
| developing, excel, mappoint, started |
| ||||
| Posted By | For | Type | Date | |
| MapPoint VBA Tutorial, Vista Gadgets, Web Site Visitors Map, MapPoint GPS API, more | This thread | Refback | 04-18-2007 03:14 PM | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| addpushpin - need help to get started | BWard | MapPoint 2006/2009 Discussion | 7 | 12-19-2005 02:15 PM |
| Getting Started with the Virtual Earth Map Control | Eric Frost | MP2K Magazine Articles | 0 | 08-02-2005 03:39 PM |
| Getting Started with VB6 and MapPoint 2004 | takk | MapPoint 2006/2009 Discussion | 3 | 12-08-2004 02:20 PM |
| I am developing an application using Mappoint web .... | Anonymous | MapPoint 2006/2009 Discussion | 0 | 08-02-2002 07:11 AM |
| I am developing an application using Mappoint web .... | Anonymous | MapPoint 2006/2009 Discussion | 0 | 12-31-1969 06:48 PM |
Dalaman Holiday
Enjoy a wonderfully peaceful Dalaman holiday... Book through UlookUbook and save!