MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Adding Excel Data as Pushpins

This is a discussion on Adding Excel Data as Pushpins within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hi, I'd like to import a set of pushpin data from excel into mappoint. I'd like to use the code ...


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

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 08-31-2006
Junior Member
White Belt
 
Join Date: Aug 2006
Posts: 5
Adding Excel Data as Pushpins

Hi,

I'd like to import a set of pushpin data from excel into mappoint. I'd like to use the code to plot pushpins according to the postcode in Column C whilst allocate the headings of 'Name 1' to column A and 'Name 2' to column B.

Eventually I would like to change the pushpin colour and style depending on the name field but for now I would appreciate help on plotting pushpins from excel according to postcodes.

Regards,

Ron
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 08-31-2006
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,055
Hi Ron,

Do you means with the standalone mappoint application ? I'm not sure if this is possible. However you can do this easy programatically in VBA or any other language.
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 08-31-2006
Junior Member
White Belt
 
Join Date: Aug 2006
Posts: 5
I'd like to do it in VBA. I have some knowledge of using VBA within excel to do simple things such as Case and IF statements but it is limited and I have tried with MapPoint but to no avail.

regards and thanks for your quick reply!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 08-31-2006
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,055
Hi,

If you do a search on this forum VBA, Excell or so, then you find a few examples on how to start. Further you can ask on this forum. Lots of people will try to help wherever possible.
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


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

Similar Threads

Thread Thread Starter Forum Replies Last Post
Adding Pushpins from Excel 2003 Marktherob MapPoint 2006/2009 Discussion 2 02-07-2006 05:13 PM
Adding Pushpins Matrices MapPoint 2006/2009 Discussion 1 11-28-2003 10:32 AM
Adding pushpins and viewing map from access project Dazzer MapPoint 2006/2009 Discussion 2 11-07-2003 05:09 AM
Is there a fast way of adding pushpins? matt1168 MapPoint 2006/2009 Discussion 3 07-24-2003 09:44 AM
in adding vendors in the excel side to be linked t.... Anonymous MapPoint 2006/2009 Discussion 1 11-14-2001 09:18 AM


All times are GMT -5. The time now is 10:33 PM.


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

French Ski Holidays
French ski holidays will suit all skiers and most taste buds too. There is a huge range of accommodation from self-catered or catered chalets to all-inclusive luxury hotels.

Travel Specialist
Travel Counsellors is a leading travel specialist. We are a Queen's Award winning travel agency.

Cape Town Flights
Book Cape Town flights through dealchecker.co.uk to get a great deal. Cape Town has fantastic weather and a wide range of activities to keep you busy.

Holidays in Egypt
A holiday in Egypt will stimulate your mind, captivate your heart and spark your senses. Visit this exceptional country, book today!

Greece
Greece covers a large area and as a result there is an abundance of things to do, see and taste. You can relax on a beach, visit ancient sites or make a trip to one of the islands like Corfu, Crete or Rhodes.

Comparison Holidays
Travel.co.uk is a travel comparison service which makes it easy for you to find and plan the best holidays.

Holidays to Fuerteventura
Come on; jump on the plane to the Canary Islands. Get information on cheap holidays to Fuerteventura at On The Beach.


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