Silent SaveAs when using the Excel win32com module

Tim Golden mail at timgolden.me.uk
Mon Sep 10 12:06:13 EDT 2007


Chris wrote:
> I'm trying to create an excel file which will act as a log, however I
> want to overwrite the file if it exists.
> 
> Looking at the SaveAs method I can't find anything that would allow
> it. I don't want the prompt to appear to ask whether to replace the
> file or not. I just want to replace it without thinking.

   xl.DisplayAlerts = 0

where xl is the Application object.

TJG



More information about the Python-list mailing list