SaveAs : Suppress Replace file dialog box

[Wesley]

Hi, I am useing the SaveAs method in Excel. When I want to save the document
over another one I get the following message:
"A file named 'C:\file.' already exists in this location. Do you want to
replace it?"

I want to suppress this dialog box and overwrite the file. I don't see an
option in the SaveAs properties do do this.

Thanks.
Wesley

 

[Macka]

Hi Wesley!
Try this.

Sub SaveDontAsk()
'Active workbook other than this
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs "C:\MyTestFile.xls"
End Sub

 

[Wesley]

Thanks Macka

It worked like a charm

Hi Wesley!
Try this.

Sub SaveDontAsk()
'Active workbook other than this
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs "C:\MyTestFile.xls"
End Sub