MapForums

I've got Excel, Word and MapPoint working quite nicely together, plotting territories from Excel and then pasting the map into Word. However, there's one thing I can't get it to do automatically:

When Excel has plotted the territories (by UK Postcode Sectors) into MapPoint - MapPoint is in the standard Legend and Overview mode, which doesn't show the Postcode Sectors. What you can do manually is press Ctrl+T or click Data -> Territories... - then MapPoint switches to Territory Manager and the Postcode Sectors are displayed. Then the macro continues and pastes into Word etc.

Any ideas how to switch into Territory Manager in VBA?

I've tried:

With objApp.ActiveMap.DataSets
szconn = "C:\Mapping Data.xls" & "!Sheet1!A:B"
Set oDS = .ImportTerritories(szconn, , geoCountryUnitedKingdom, , geoImportExcelA1)
Application.DisplayAlerts = False
Set oDS = .ShowImportTerritoriesWizard
Application.DisplayAlerts = True
End With

but keep getting an error that the Import Territories Wizard cannot run because there is already a DataSet present.

Ha! Just solved it myself. You need a statement like:

objApp.PaneState = geoPaneTerritory

(where objApp is a MapPoint.Application)

hi,

thanx for feedback

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
MapPoint coding demo
Order MapPoint 2009 with Routing and User Tools Spreadsheet

Did you try running the territory creation before the data input portion of your macro? I'm getting ready to do a project with mappoint and excel and seem to be constantly frustrated about a lack of clear documentation regarding how the mappoint object model components work...