MapPoint Forums

MapForums

Community of VE/MapPoint 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 2006/2009 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 2006/2009 Discussion

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



Click here to register

Reply

 

LinkBack (3) Thread Tools Display Modes
  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
Blue Belt
 
Join Date: Dec 2002
Posts: 248
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
Posts: 2,112
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: 2,466
Blog Entries: 1
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 2006/2009 Discussion 1 4 Weeks Ago 04:31 AM
Export to excel Dazzer MapPoint 2006/2009 Discussion 0 10-23-2003 05:29 AM
export to excel gsully MapPoint 2006/2009 Discussion 0 05-08-2003 10:39 AM
How to highlight a pushpin imported from Excel? indyalt MapPoint 2006/2009 Discussion 1 04-14-2003 02:12 AM
I want to be able to export to excel a file that h.... Anonymous MapPoint 2006/2009 Discussion 1 07-18-2001 01:29 PM


All times are GMT -5. The time now is 08:55 AM.


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


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