MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




VBA with Embedded Maps in MS Office?

This is a discussion on VBA with Embedded Maps in MS Office? within the Development forums, part of the MapPoint 2006/2009 Discussion category; I am having probems embedding a MapPoint map in Excel and then controlling the embedded map with VBA code. I ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion > Development

VBA with Embedded Maps in MS Office? VBA with Embedded Maps in MS Office?

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read


Notice: Now taking orders for MapPoint 2009!


Click here to register

Reply

 

LinkBack (7) Thread Tools Display Modes
  7 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 08-23-2007
Junior Member
White Belt
  
Join Date: Aug 2007
Posts: 2
VBA with Embedded Maps in MS Office?
I am having probems embedding a MapPoint map in Excel and then controlling the embedded map with VBA code. I am not sure how to reference the map. MS Excel seems to refer to the object as a shape... if I try to record a macro while making some changes to the map to get a better idea of what to do, the resulting code selects the shape and then uses some generic code like "Selection.Verb Verb:=xlPrimary".

I have tried to write some code to reference the shape such as:

----------
Dim myMap As MapPoint.Map
Set myMap = ActiveSheet.Shapes("Object 3")
----------

Also tried:

----------
Dim myMap As MapPoint.Map
Set myMap = ActiveSheet.Shapes("Object 3")
----------

But both result in "Type mismatch" errors.

Am I missing an obvious way to reference the embedded map? Thanks for the help!
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 08-23-2007
Junior Member
White Belt
  
Join Date: Aug 2007
Posts: 2
Re: VBA with Embedded Maps in MS Office?
[Correction to the original post]

The 2nd code snippet should read:

----------
Dim myApp As MapPoint.Application
Set myApp = ActiveSheet.Shapes("Object 3")
----------
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

Tags
embedded, maps, office, vba

« Optimize Hangs | Resizing the MapPoint control at run-time »

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/vba-embedded-maps-ms-office-6185.html
Posted By For Type Date
Working With Excel and MapPoint - MP2K Magazine This thread Refback 09-04-2007 06:54 AM
Microsoft MapPoint 2006 - MP2K Magazine This thread Refback 08-29-2007 09:25 AM
Microsoft MapPoint 2006 - MP2K Magazine This thread Refback 08-29-2007 09:25 AM
Tracking P.F. Chang’s in the Midwest - MapPoint Articles - MP2K Magazine This thread Refback 08-28-2007 04:28 PM
Creating Geocoding Exceptions for MapPoint Web Service Applications - MapPoint Articles - MP2K Magazine This thread Refback 08-27-2007 09:07 AM
Merging Multiple Routes - MapPoint Articles - MP2K Magazine This thread Refback 08-25-2007 05:28 AM
mappoint: Blogs, Photos, Videos and more on Technorati This thread Refback 08-25-2007 12:46 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes
Linear Mode Linear Mode

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
General embedded MapPoint questions satacoy MapPoint 2006/2009 Discussion 1 09-18-2007 05:07 PM
Embedded Graphics and MP Control Anonymous MapPoint 2006/2009 Discussion 3 01-27-2005 04:18 PM
updating an embedded map in Excel Anonymous MapPoint 2006/2009 Discussion 0 08-26-2004 12:44 PM
MP 2002: does it do the job also with non-XP Office? pwy MapPoint 2006/2009 Discussion 2 05-14-2003 05:29 PM
Mappoint control in an Office Application using VBA ToddRCS MapPoint 2006/2009 Discussion 1 11-19-2002 04:00 PM


All times are GMT -5. The time now is 10:07 AM.

Marketing Strategy - VSAT - Used Cars - Book a Hotel - Starcraft 2 - Archive - Top

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

Catered Ski Chalet
Hoping to book a catered ski chalet? Make sure you visit Holiday Hypermarket and search for accommodation to suit your holiday requirements.

City Break Europe
Take a City Break in Europe. Based on holidays booked this year, these are the most popular City Breaks for 2006

Holidays Thailand
Holidays in Thailand are hugely diverse with wonderful luxury resorts and beaches but also some lovely forested mountains with interesting hill tribes. See dealchecker.co.uk.

Cyprus Holidays
Cyprus holidays will offer you a wealth of activities all in the most beautiful surroundings. Relish the beauty of Cyprus on a short break.

Cheap Balearics Holidays
Cheap Balearics holidays are available if you know when to book and who to book with. The Balearics have many fascinating places to visit all year round. The partying never stops.

Price Compare
Visit Travel.co.uk for and compare not only price, but also the wide variety of options available.

Lanzarote Holidays
Visit the easternmost island of the archipelago! Book Lanzarote 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 48 49 50 51 52