automatically overwrite when saved

khickey · Apr 25th, 2002, 05:10 PM

I want to use VBA to save a workbook and I want it to automatically overwrite the existing box without me having to click in a dialog box everytime.... is there VBA code that will do an automatic overwrite when saving?

Thanks in advance!

Qroozn · Apr 25th, 2002, 05:13 PM

Application.DisplayAlerts = False
ActiveWorkbook.Save
Application.DisplayAlerts = True

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

Apr 25th, 2002, 05:10 PM	#1
khickey New Member Join Date: Apr 2002 Posts: 16	I want to use VBA to save a workbook and I want it to automatically overwrite the existing box without me having to click in a dialog box everytime.... is there VBA code that will do an automatic overwrite when saving? Thanks in advance!

Apr 25th, 2002, 05:13 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	Application.DisplayAlerts = False ActiveWorkbook.Save Application.DisplayAlerts = True