FILE.CLOSE

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