I am using vba from excel 2002(XP) and adding some mappoint functionality. I got it to show the map using the following code .

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

objApp.ActiveMap.CopyMap
Worksheets("Demand_Maps").Select
Worksheets("Demand_Maps").Range("e8").Select 'Select e8
Worksheets("Demand_Maps").Paste[/vba]

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.
Thanks,
Reza