MapForums

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

__________________