Overwrite file with same name

[Tigrou25]

Hi there,

I try to overwrite a file when I save it.

I have put the following code but it doesn't work, it asks me if I want ro replace the file.

Application.DisplayAlerts = False

I have also tried

ActiveWorkbook.Application.DisplayAlerts = False

Here the full code

ActiveWorkbook.SaveAs Filename:= _        "S:\Construction\National - Head Office\A Profit and Loss\A01 FY Budgets\08. FY19 P&L\1.Monthly P&L Review\Excel\1. NAT CONST CMT P&L.xlsx" _
        , FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
 ActiveWorkbook.Application.DisplayAlerts = False
        ActiveWindow.Close

 

[Domenic]

You need to set the DisplayAlerts property to False before saving your workbook...

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs ...

 

[Tigrou25]

Simple as that. It works perfectly. Thanks !

 

[Domenic]

You're very welcome!

Cheers!