Silent SaveAs when using the Excel win32com module

[Chris]

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.

Thanks in advance.

 

[Chris]

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.

Thanks in advance.

Googling around I found that a way around this is to just delete the
file before you save (if it exists)... any other solutions?

 

[Tim Golden]

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

 

[MRAB]

Check if the file exists and delete it before saving the new one.

It's more Pythonic to delete the file and catch the exception if it
doesn't actually exist.