Saving a Workbook (while suppressing the typical confirmation dialogs):   Return to List

Application.DisplayAlerts = False' Without asking permission
ActiveWorkbook.SaveAs FileName:=MyTemp & ".xls", FileFormat:= xlNormal, _
    Password:="", WriteResPassword:="", _
    ReadOnlyRecommended:=False, _
    CreateBackup:=False
Application.DisplayAlerts = True' Turning it back on

See also:
Built-In Dialogs and Argument Lists
Closing a Workbook (with options)
Create new Workbook from Worksheet
Deleting a Workbook (i.e., File)
Filename of the active Workbook (full path/name)
File Open Dialog (for browsing and selecting files)
File SaveAs Dialog (for saving files)
Opening a Workbook (known filename)
Working with Workbooks



Note to Webmaster