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