set the following property to 0. It will not prompt the user. ExcelApp.DisplayAlerts = 0
-----Original Message----- From: Dan Palmer [mailto:[EMAIL PROTECTED]] Sent: Friday, 8 March 2002 1:31 AM To: [EMAIL PROTECTED] Subject: Deletion of worksheet without confirmation dialog When using win32com how does one delete a sheet from a workbook either by name or by number without the confirmation dialog prompt. >import win32com.client >ExcelApp= win32com.client.Dispatch("Excel.Application") >ExcelApp.Worksheets.Add() >sht = ExcelApp.Worksheets(1) >sht.Delete() >>at this point it generates a confirmation dialog, if I acknowledge the >>dialog it does delete the proper sheet. Is there a way to turn the >>confirmation off (either as a preference, or as a parameter to delete) Thanks in advance _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx _______________________________________________ ActivePython mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs _______________________________________________ ActivePython mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
