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

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

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

Hi,

Yes every point is a waypoint object each with a location property that you can use for a pushpin.

Thank you Wilfried!

I have another little question.

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

Thank again!

A.Ouellet

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

Eric