SaveAs - Automatically overwrite existing file

Mar 14th, 2002, 04:24 PM

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 · Mar 14th, 2002, 04:29 PM

Hi,

Put in

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

This will stop the message popping up.

Regards,
D

Mar 14th, 2002, 04:43 PM

Awesome, thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 04:24 PM	#1
Guest Posts: n/a	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?

Mar 14th, 2002, 04:29 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hi, Put in Application.DisplayAlerts = False 'Then save your workbook Application.DisplayAlerts = True This will stop the message popping up. Regards, D