MapForums

Hi ,

I have map open using activex control. Map has some Territories name created manually( no linking or import). I would like to retreived the Territories name as string.

This is possible if you import Map from excel file and i can read all records

Set mpDataSet = .ImportTerritories(szconn, , geoCountryUnitedStates, , geoImportExcelA1)

Set objRecordset = mpDataSet.QueryAllRecords
This way i can navigate to all record and get the Territories names.

BUT i don't see any object in MapPoint 2002 which allows me to read the same info from manually created Territories .

Any idea please.

Thanx in advance.

I guest MapPoint does not provide enough of information on Territories.

Does any body know more about object required to read the Territories content of .ptm file

Here is the code to read the linked Territory. I was wondering if some body has dome the same but with Manually created Territory

With objMap.DataSets
szconn = objMap.Path & "C:\MapPoint\pushpin\Terrs.xls!Sheet1!A1:E127"
Set mpDataSet = .ImportTerritories(szconn, , geoCountryUnitedStates, , geoImportExcelA1)
End With

Dim objRecordset As Recordset
Set objRecordset = mpDataSet.QueryAllRecords
Dim strLookUp As String
ReDim Preserve strRegion(0)
x = 0
'Get the values
Dim vals As String
objRecordset.MoveFirst
Dim i As Integer
Do Until objRecordset.EOF
strLookUp = Trim(objRecordset.fields("Territory"))
ReDim Preserve strRegion(x)
strRegion(x) = strLookUp // I have the list here...
x = x + 1
End If
objRecordset.MoveNext

Loop