[RESOLVED] Overwriting existing workbook

[thelocaluk]

Is there a way to automatically overwrite an existing workbook to avoid this message "WorkBook already exists, do you want to replace it?", without the need to select yes.

[mikeyc1204]

Application.DisplayAlerts = False
'Save As
Application.DisplayAlerts = True

[thelocaluk]

Cheers Mikey, it works a treat.