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]

On Sep 10, 11:57 am, Chris <[e-mail]:

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]

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

[MRAB]

On Sep 10, 5:24 pm, "Hamilton, William " <[e-mail]:

From: 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.

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.