MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Can MapPoint do This?

This is a discussion on Can MapPoint do This? within the MapPoint 2006/2009 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 ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-10-2006
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
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 01-11-2006
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,105
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.
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 01-12-2006
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,105
Hi,

Quote:
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.
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
mappoint


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


All times are GMT -5. The time now is 07:42 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Family Skiing
Whether you are looking for family skiing or just a ski holiday for a couple, visit Holiday Hypermarket. Check out the latest deals online.

Portugal Weather
Check out Portugal Weather - Travel Counsellors details information on Portugal including, weather, flights and accommodation.

Thailand Holiday
A Thailand Holiday has much to offer with historic culture, lively arts, beautiful beaches, a good nightlife, friendly and hospitable people and one of the best cuisines in the world.

Egypt Holidays
Visit one of the most spectacular sightseeing destinations in the world with The Holiday Place. Egypt holidays provide a fantastic break!

Cheap Canaries Holidays
Are you hunting down cheap Canaries holidays? Well check out ulookubook.com to bag a great value holiday. There are numerous festivals taking place all year round. Why not book your holiday around one?

Travel Guides
As far as travel guides are concerned, your best move would be to check out our website at Travel.co.uk

Cheap Holidays in Florida
Legendary weather! Visit On The Beach for info on cheap holidays in Florida.


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