Saving a new added workbook with existing name on HD, but without being prompted.

[MarMo]

Hi there ,
I'd like to save a new added workbook and overwrite an existing file on the HD.
I have a file named c:\barcodes.xls"
The code below gives me a prompt :

"A file named 'C:\barcodes.xls' already exists in this location.Do you want to replace it?"

        New_file_name = "C:\barcodes.xls"
        ActiveWorkbook.SaveAs Filename:=New_file_name, FileFormat:=xlNormal

Is there a way or workaround to save the file without the prompt.?
Thanks for helping me out.

[wamp]

Application.DisplayAlerts = False
' Your save code
Application.DiplayAlerts = True

should take care of it for for you.

[MarMo]

Wamp,
Thanks for the quick reply ( as always on this forum )
I should have searched the net first , cause i found this also on other sites.
thanks and see u on this forum.