Community of VE/MapPoint 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 ...
| |||||||
| 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
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
__________________ Order MapPoint 2006 | Read Programming MapPoint in .NET | Start Using the Pushpin Tool - Free Trial Download - click here. |
| |||
| 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
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
__________________ Order MapPoint 2006 | Read Programming MapPoint in .NET | Start Using the Pushpin Tool - Free Trial Download - click here. |
![]() |
| ||||
| 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 07:00 PM |
Cheap Flights to Sharm
Cheap flights to Sharm El Sheikh are easy to book when you use Holiday Hypermarket. Great weather and wonderful watersports await.
Flights to Cyprus
Find cheap flights to Cyprus on Travel Counsellors. A personal Travel Counsellor can help you plan flights and find accommodation in Cyprus.
Cheap Flights to Cape Town
Here at dealchecker.co.uk we’ll shop around for cheap flights to Cape Town so you don’t have to. Find and Compare prices from over twenty UK travel agents with just one search.
Nile Cruises
Nile cruises are one of the best ways to discover the riches of Egypt. See ancient ruins and lush verdure from the River Nile. Book today!
Egypt
In Egypt you find an ancient city buzzing with life. There is an abundance of historical sites to see, not just the pyramids. The Opera House is certainly worth a visit and you can enjoy some open-air theatre too.
Price Comparison
Price comparison is the name of the game at Travel.co.uk. Visit our website and see for yourself.
Cheap Fuerteventura Holidays
Enjoy the deep sands of the Canary Islands. Find cheap Fuerteventura holidays at On The Beach!