MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Developing with MapPoint and Excel - Getting Started

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 ...


Go Back   MapPoint Forums > Map Forums > MP2K Magazine Articles

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 09-29-2004
Eric Frost's Avatar
Administrator
Black Belt
 
Join Date: Jul 1992
Posts: 2,210
Blog Entries: 1
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/mappoi.../#features_sec

Click Post Reply to post a question or comment.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 10-11-2004
Junior Member
White Belt
 
Join Date: Nov 2003
Posts: 1
Send a message via Yahoo to afryan
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 11-15-2007
Junior Member
White Belt
 
Join Date: Nov 2007
Posts: 1
Red face Re: Developing with MapPoint and Excel - Getting Started

[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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 11-16-2007
Eric Frost's Avatar
Administrator
Black Belt
 
Join Date: Jul 1992
Posts: 2,210
Blog Entries: 1
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 02-27-2008
Junior Member
White Belt
 
Join Date: Feb 2008
Posts: 6
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6 (permalink)  
Old 02-27-2008
Eric Frost's Avatar
Administrator
Black Belt
 
Join Date: Jul 1992
Posts: 2,210
Blog Entries: 1
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/developing-mappoint-excel-getting-started-3301.html

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -5. The time now is 11:18 PM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC5
MP2K Magazine
Visitor Map

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!


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47