I am new to Mappoint 2004 and I am trying to map values using the DisplayDataMap method. I am using the Active X Control and VBA from within Excel 2003. Here is the code I am running:

Set objDataMap = objDataSet.DisplayDataMap(geoDataMapTypeMultipleSy mbol, objField, geoShowByStreetAddress, geoCombineByDefault, geoRangeTypeUniqueValues, geoRangeOrderDefault, , UBound(lRangeValues) + 1, lRangeValues, zRangeNames, , lSymbols)

This maps the data from an Excel spreadsheet on a multiple symbol map and everything is fine; however, I then want to map a subset of this data so I do the following:

tValues(0) = lRangeValues(arrayx)
tNames(0) = zRangeNames(arrayx)
tSymbols(0) = "c:\red.bmp"
Set objDataMap = objDataSet.DisplayDataMap(geoDataMapTypeMultipleSy mbol, objField, geoShowByStreetAddress, geoCombineByDefault, geoRangeTypeUniqueValues, geoRangeOrderDefault, , UBound(tValues) + 1, tValues, tNames, , tSymbols)

In the above example arrayx refers a single subset of the dataset used before. This does what I want except for the custom symbol array. The data maps but uses the default symbol (black circle) for the data set.

I have tried changing both the datasets and individual pushpin symbols but I get a runtime error 4010: saying that I can't access that property.
I am really getting frustrated and any help would be appreciated.

Never mind, I figured it out. Thanks.

What was wrong? other people may have the same or similar problem.

Eric

Originally Posted by Eric Frost

What was wrong? other people may have the same or similar problem.

Eric

I faced a similar situation and was about to give up and finally figured out it was a very simple solution to the problem.

You will have to first create the Symbol Object and the assign the Sybmol.ID in place of the file name

tSymbols(0) = "c:\red.bmp"
>>
actually should be
tSymbols(0) = oSymbol.ID

Hope it helps someone in a similar situation

Cheers