Overwriting workbook code 1

[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.

 

[SkipVought]

Hi,

Application.DisplayAlerts = False

then save

then set back to True

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}

 

[thelocaluk]

Cheers Skip