MapForums

bobil · #1 (**permalink**) 05-24-2006

Hi everybody,
I am totaly new to mappoint and mappoint "programming".
I don't know if it is the right place to post so please excuse me if I am wrong.

Let me explain my problem.
I have a list of locations and I would like to place them on a mappoint map and draw a line between them (just a normal straight line for the beginning).
The list of locations and "routes" can be in either excel, access or sql format and if possible i would like a vba macro to do it.

So is this possible ? and how ?

Thank you very much.

Bob.
PS : If you happen to know any good tutorials about how to use excel and mappoint please be kind enough to post the url.

Mohamed · #2 (**permalink**) 05-25-2006

Hi,

Hope this will help:

1- Looking at the Mappoint HelpFile, you have this example:

Code:

Sub AddLineToMap(FromAddress1, To Address2)

  Dim objApp As New MapPoint.Application
  Dim objMap As MapPoint.Map
  Dim objLoc1 As MapPoint.Location
  Dim objLoc2 As MapPoint.Location

  'Configure l'application
  Set objMap = objApp.ActiveMap
  objApp.Visible = True
  objApp.UserControl = True

  'Obtient deux lieux et les agrandit
  Set objLoc1 = objMap.FindResults(FromAddress1).Item(1)
  Set objLoc2 = objMap.FindResults(ToAddress2).Item(1)
  Set objMap.Location = objLoc1

  'Ajoute un trait reliant les deux lieux
  objMap.Shapes.AddLine objLoc1, objLoc2

  End Sub

2- You have to buy this book, you can find it in the homepage fo this website:

MP2K is pleased to offer MapPoint For Dummies to our North American readers at the lowest price available anywhere.

At $17.48 + $2.50 shipping, that is around $2 cheaper than other major Internet book retailers.

3- Do a search in this forum with keys as "excel", you will find all what you need

Ciao

WonderMonkey · #3 (**permalink**) 05-25-2006

I have purchased the O'Reilly book. It arrives next week. If you are going to purchase a book I'll do a review on it if you wish.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
draw simple line between points	Anonymous	MapPoint 2006/2009 Discussion	0	07-27-2004 04:15 AM
Points in a straight line	Dazzer	MapPoint 2006/2009 Discussion	6	05-25-2004 11:27 AM
As I draw a line and then a pushpin on that line, ....	Anonymous	MapPoint 2006/2009 Discussion	1	07-16-2002 08:35 AM
Hi I have a problem. When i draw a line and the....	Anonymous	MapPoint 2006/2009 Discussion	1	07-15-2002 10:06 AM
How do i change the default Line draw width (toolb....	Anonymous	MapPoint 2006/2009 Discussion	1	12-26-2001 11:39 AM

MapForums

how to draw a line between points

how to draw a line between points

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

MapForums

how to draw a line between points

how to draw a line between points

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads