MapForums

Hi all,
I'm new to the Mappoint program and all that it entails.
What I am trying to do is this:
import addresses from an excel spreadsheet and have each pin show up as a number associated to a number on the spreadsheet.
For instance: if I have a spreadsheet with the following columns and 20 rows (or more): Number, Street Address, City, State, Zip. How can I make mappoint put numbered pins down that correspond to the number column in the spreadsheet. (or is there another way, possibly using the row numbers, or to create my own pins and associate them somehow?)

Thanks for any advice you can provide!

It depends!
(a) do you want a pin: (i) with a number on it, or (ii)simply a description associated with the pin which has the row data?
(b) are you expecting to import excel data into Mappoint or run this using VBA from Excel?
If you want (a.i) then there is a limited option to do this by using the pin icons with successive numbers on (they don't go very high) but you will want to do this using VBA.
If you want (a.ii) you could use Mappoint import: create a formula in excel with the row address (using Address function) and then use that column as the location description column.
I am happy to describe further if you clarify your aim.

Thanks for the quick response!

yes, I am aiming for ai, but the pin has to match a number from the spreadsheet. Have been doing it manually, but that's incredibly time-consuming.

Am not sure what VBA is?

The goal is to be able to differentiate the pins on the map without having to click on them to get the address information. Likely to be more numbers than what's listed in mappoint, but can deal with that later...

VBA is Visual Basic for Applications (ie the macro language in Excel).
If you are not familiar with it, there are some good articles on the site about getting VBA to talk to Mappoint and then put the data into Excel. You probably want to start there. Basically you need to reference Mappoint within the VBA editor.
The numbered pins are graphic, so you can't program the numbers directly. They start at symbol#208 (pin with '1' on it, 209 has '2' etc)
so you need to place pushpins on the map and change the symbol to the right symbol# for your row (I don't know how high these numbered pins go - not far I think, but there is continuing set with a different symbol number range. (a link to the full list of symbol numbers must be somewhere on the site).

The code, when you get there, will need to be something like: