MapPoint Forums

MapForums

Community of MapPoint and Bing Maps Users and Developers




Export route highlight in PowerPoint or Excel

This is a discussion on Export route highlight in PowerPoint or Excel within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi, I am using MapPoint with VBA. Here is the description of what I want to do: I want 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 07-25-2007
Junior Member
White Belt
 
Join Date: May 2007
Location: Montreal
Posts: 11
Question Export route highlight in PowerPoint or Excel

Hi,

I am using MapPoint with VBA.

Here is the description of what I want to do:
I want to export the route drawing (when MapPoint calculate a distance between two cities, it highlight the route) in excel or powerpoint. I want to do that because I want to draw a line over the route.

Any advice?

Thank you

A.Ouellet
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 07-25-2007
Senior Member
Red Belt
 
Join Date: Dec 2002
Posts: 568
Re: Export route highlight in PowerPoint or Excel

Hi Well,

You can

1) Use File ... Copy Map and then paste into Excel
2) SaveAsWebpage and import the resulting gif
3) Get a capture utility with Extended Window (Hypersnap, SnagIt, etc)
4) See Printing a Map from Mappoint

Mike Mattys
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 07-27-2007
Junior Member
White Belt
 
Join Date: May 2007
Location: Montreal
Posts: 11
Re: Export route highlight in PowerPoint or Excel

Hi Mike and everybody,

Thanks for your answer, but it is not really what I need. I will try to ask another question.

Description of what I want to do:

I calculate the route between 2 cities with a VBA application. To go from the first city to the second, the route passes through other cities. Is there a way to pushpin these cities or use them as an object with VBA?

Thanks,

A.Ouellet
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 07-27-2007
Senior Member
Black Belt
 
Join Date: Nov 2004
Location: Belgium
Posts: 2,308
Re: Export route highlight in PowerPoint or Excel

Hi,

Yes every point is a waypoint object each with a location property that you can use for a pushpin.
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 07-31-2007
Junior Member
White Belt
 
Join Date: May 2007
Location: Montreal
Posts: 11
Re: Export route highlight in PowerPoint or Excel

Thank you Wilfried!

I have another little question.

How can I know how many waypoints there is in a route?

Thank again!

A.Ouellet
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 07-31-2007
Eric Frost's Avatar
Senior Member
Black Belt
 
Join Date: Jul 1992
Posts: 3,420
Blog Entries: 3
Re: Export route highlight in PowerPoint or Excel

The WayPoints Collection has a count property - see the help file

Eric
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
excel, export, highlight, powerpoint, route


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/export-route-highlight-powerpoint-excel-6102.html

Posted By For Type Date
Using Virtual Earth to Write a Vista Gadget That Tracks the International Space Station - MapPoint Articles - MP2K Magazine This thread Refback 07-30-2007 10:40 PM
Working With Excel and MapPoint - MP2K Magazine This thread Refback 07-28-2007 02:50 AM
MapPoint Forums - MapPoint 2006, MWS, and Virtual Earth Discussion This thread Refback 07-25-2007 05:13 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
How to export data to excel using C# xortam MapPoint Desktop Discussion 4 08-12-2009 10:59 AM
Export to excel Dazzer MapPoint Desktop Discussion 0 10-23-2003 05:29 AM
export to excel gsully MapPoint Desktop Discussion 0 05-08-2003 10:39 AM
How to highlight a pushpin imported from Excel? indyalt MapPoint Desktop Discussion 1 04-14-2003 02:12 AM
I want to be able to export to excel a file that h.... Anonymous MapPoint Desktop Discussion 1 07-18-2001 01:29 PM


All times are GMT -5. The time now is 07:59 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