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