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
  #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
Mattys Consulting's Avatar
Senior Member
Red Belt
 
Join Date: Dec 2002
Posts: 670
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,389
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,580
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


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 09:59 AM
Export to excel Dazzer MapPoint Desktop Discussion 0 10-23-2003 04:29 AM
export to excel gsully MapPoint Desktop Discussion 0 05-08-2003 09:39 AM
How to highlight a pushpin imported from Excel? indyalt MapPoint Desktop Discussion 1 04-14-2003 01:12 AM
I want to be able to export to excel a file that h.... Anonymous MapPoint Desktop Discussion 1 07-18-2001 12:29 PM


All times are GMT -5. The time now is 05:01 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.5.0 RC3
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 68 69