Macro Sheets Only
Equivalent to choosing the Close command from the File menu. Closes the active workbook.
Syntax
FILE.CLOSE(save_logical, route_logical)
Save_logical is a logical value specifying whether to save the file before closing it.
Save_logical Result
TRUE Saves the workbook
FALSE Does not save the workbook
Omitted If you've made changes to the workbook, displays a dialog box asking if you want to save the workbook
Route_logical is a logical value that specifies whether to route the file after closing it. This argument is ignored if there is not a routing slip present.
Route_logical Result
TRUE Routes the file
FALSE Does not route the file
Omitted If you've specified recipients for routing, displays a dialog box asking if you want to save the file
Remarks
If you make any changes to the structure of a workbook, such as the name of sheets, their order, and so on, then a message will be displayed reminding you that there are unsaved changes, regardless of the save_logical value.
Note When you use the FILE.CLOSE function, Microsoft Excel does not run any Auto_Close macros before closing the workbook.
Related Functions
CLOSE Closes the active window
CLOSE.ALL Closes all unprotected windows
FCLOSE Closes a text file
List of Command-Equivalent Functions