Adding Excel Data as Pushpins

rosshood10
08-31-2006, 09:31 AM
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

Wilfried
08-31-2006, 10:27 AM
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.

rosshood10
08-31-2006, 11:01 AM
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!

Wilfried
08-31-2006, 11:25 AM
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.

 
Web mp2kmag.com
mapforums.com