SaveAs - Automatically overwrite existing file

[Guest]

I am running a daily report that is saved to a network drive. Since there are links on the Intranet to this file, it has be saved as the same file name everyday, just overwrite the existing one. Question is, how do I get my macro to save the file as that same file name and automatically overwrite the existing file, without popping up and asking me if I want to overwrite?

 

[dk]

Hi,

Put in

Application.DisplayAlerts = False
'Then save your workbook
Application.DisplayAlerts = True

This will stop the message popping up.

Regards,
D

 

[Guest]

Awesome, thanks!