Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 6 of 6

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 ...

  1. #1
    Well is offline 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

  2. #2
    Mattys Consulting's Avatar
    Mattys Consulting is offline Senior Member Black Belt
    Join Date
    Dec 2002
    Posts
    1,040

    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

  3. #3
    Well is offline 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

  4. #4
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

    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.

  5. #5
    Well is offline 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

  6. #6
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    Re: Export route highlight in PowerPoint or Excel

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

    Eric

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to export data to excel using C#
    By xortam in forum MapPoint Desktop Discussion
    Replies: 7
    Last Post: 02-15-2012, 09:00 AM
  2. Export to excel
    By Dazzer in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-23-2003, 05:29 AM
  3. export to excel
    By gsully in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-08-2003, 10:39 AM
  4. How to highlight a pushpin imported from Excel?
    By indyalt in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 04-14-2003, 02:12 AM
  5. I want to be able to export to excel a file that h....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-18-2001, 01:29 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


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 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96