View Full Version : How to disable the save dialog box in mappoint ?

02-23-2005, 07:27 AM
I am using vba from excel 2002(XP) and adding some mappoint functionality. I got it to show the map using the following code .

objApp.ActiveMap.DataSets.ShowDataMappingWizard _
DataSetToUse:=objDataSet, StartPage:=geoDataFieldsPage

Worksheets("Demand_Maps").Range("e8").Select 'Select e8

This puts the pie chart in the Demand_Maps sheet. Now I have two questions :
1. As soon as it copies the map to the sheet .. it shows a Mappoint dialog box with the message 'Save Changes to Map?' . Is there anyway to disable that dialog box so that it does not appear ?

2. It only copies the map to the spreadsheet but not the legends for different colors in the pie chart. But when you use the actual mappoint software it shows the maps with the pie chart and to the left of it is the legends diagram.

I would really appreciate your help.

Zack Barresse
02-23-2005, 04:29 PM
Hi Reza,

For supressing the message box you are getting, can you turn off events for this? E.g. ...
Application.EnableEvents = False
'other code here
Application.EnableEvents = True
As for #2, I don't use MapPoint, sorry. :(

see this