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 3 of 3

Can MapPoint do This?

This is a discussion on Can MapPoint do This? within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am trying to figure out if MapPoint 2004 will import from excel the following information: Have a street segment ...

  1. #1
    curious is offline Junior Member White Belt
    Join Date
    Jan 2006
    Posts
    1

    Can MapPoint do This?

    I am trying to figure out if MapPoint 2004 will import from excel the following information:

    Have a street segment and the first and last cross streets.

    (e.g. James Street from King Street to Wellington Street)

    What I'm trying to achieve is for MapPoint 2004 to read the xls spreadsheet and plot out a line segment on the map. Then if possible, export the line segment with the lat and long co-ordinates. I have several hundred segments to do across Canada.

    Anybody done this or can this be done in MapPoint 2004?

    Curious

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

    I'm not sure what you mean by 'plot out a line segment', but you can read the excell in your program, let handle mappoint what you wants it to do and write again yourself in your program to the excell sheet.

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

    What I'm trying to do is having a spreadsheet that has a street name in one column and then two subsequent columns
    with the first cross street and second cross street. In other words a street segement. If I can import this
    information into mappoint from excel, then I would like instead of pushpins, mapoint to draw a route on the road
    segement from the first cross street to the second cross street. Once I have this route drawn on the map, then if
    possible could I export the lat/long or any other type of reference information back to excel so the reference could
    be used in other mapping program
    Import / export is not a problem, also you can do a lot in VBA like drawing the road segment. However there is 1 main problem, you dont have the coordinates of the crosspoint itself (or do you ?).

    If you ask mappoint to draw a route from a street to another street, I think it will draw it from the middle of the street or maybe one of the endpoints, but a crosspoint I dont think this can be done without coordinates.

Thread Information

Users Browsing this Thread

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

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