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.
Printable View
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.
VB Code:
Application.DisplayAlerts = False 'Save As Application.DisplayAlerts = True
Cheers Mikey, it works a treat.