MapPoint Forums

MapForums

Community of MapPoint and Bing Maps Users and Developers




Embedding map in excel worksheet

This is a discussion on Embedding map in excel worksheet within the MapPoint Desktop Discussion forums, part of the Map Forums category; Does anyone know how I can embed an interactive MapPoint map on an excel worksheet using vba. It’s straightforward to ...


Go Back   MapPoint Forums > Map Forums > MapPoint Desktop Discussion

Today's Posts Twitter Feed Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  3 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 06-18-2009
Senior Member
Blue Belt
 
Join Date: Oct 2003
Location: London
Posts: 269
Embedding map in excel worksheet

Does anyone know how I can embed an interactive MapPoint map on an excel worksheet using vba. It’s straightforward to do this for a non-interactive map using the cut and paste procedure described here

Using MapPoint from Word, Access and Excel

However I need to have the map so that the pushpin balloon opens when it’s clicked on. Can anyone point me in the right direction?

Thanks
__________________
David
UK mapping and map analysis services at www.broomanalysis.plus.com

Last edited by Eric Frost; 06-18-2009 at 02:04 PM..
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 06-18-2009
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 3,418
Blog Entries: 3
Re: Embedding map in excel worksheet

There's actually another article about embedding... although it talks about Word, it should be the same for Excel I think.
10 Second Tutorial: Embedding With Word
Eric
__________________
~ Now taking orders for MapPoint 2010 ~
~~
~ Upgrade to MapForums Plus membership ~
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 06-18-2009
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 3,418
Blog Entries: 3
Re: Embedding map in excel worksheet

By the way, look at the bottom of the articles page --
MapPoint Articles - MP2K Magazine

MP2K Magazine turned 10 years old a couple months ago! Yay!

Eric
__________________
~ Now taking orders for MapPoint 2010 ~
~~
~ Upgrade to MapForums Plus membership ~
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 06-18-2009
Senior Member
Blue Belt
 
Join Date: Oct 2003
Location: London
Posts: 269
Re: Embedding map in excel worksheet

First of all congratulations on the tenth anniversary. It’s quite apt as MP Europe becomes increasingly tinny, but this forum continues as an informative and enthusiastic hub for all kinds of users from zealots right through to cynics.

Also thanks for the link. Unfortunately though that article uses the standard add-in for integrating maps into Office documents , whereas I want to automate the process with code. Interestingly in the link I gave in the first post on this thread, where the author talks about embedding maps into Access he uses the code

Code:
 oMap.CopyMap			
 imgClip.Visible = True
 imgClip.Action = acOLEPaste
which I think (haven’t actually tested it) would end up with an interactive map. What I need is the equivalent for Excel.
__________________
David
UK mapping and map analysis services at www.broomanalysis.plus.com
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
embedding, excel, map, worksheet


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/embedding-map-excel-worksheet-10655.html

Posted By For Type Date
Excel AL | outside.in This thread Refback 09-07-2009 12:48 AM
MapPoint chat transcript, Alliance Program, using MapPoint with SDE and Excel XP - MP2K Update Archives - MP2K Magazine This thread Refback 06-18-2009 03:38 PM
The Magazine for MapPoint - MP2K Magazine This thread Refback 06-18-2009 02:04 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
SMF Youtube Embedding niknaf General Chat 3 08-15-2008 05:23 PM
Copying Worksheet with Combo Box Anonymous MapPoint Desktop Discussion 0 07-20-2004 05:13 PM
how to creat an Excel worksheet with C++Builder 5 Anonymous MapPoint Desktop Discussion 1 04-17-2004 04:10 PM
Embedding a map in an Access report Anonymous MapPoint Desktop Discussion 2 10-14-2002 11:27 AM
10 Second Tutorial: Embedding With Word Anonymous MP2K Magazine Articles 0 07-01-2001 12:48 AM


All times are GMT -5. The time now is 01:29 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.2
MP2K Magazine
Visitor Map



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 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67