Equivalent to choosing the Summary Info command from the File menu. Generates the summary information for the active workbook.
Syntax
SUMMARY.INFO(title, subject, author, keywords, comments)
SUMMARY.INFO?(title, subject, author, keywords, comments)
The arguments correspond to the text boxes in the Summary Info dialog boxes. If any arguments are omitted, that text box is left empty.
Title specifies a title for the file, not necessarily a file name. Long names can be entered, up to 255 characters.
Subject is information pertaining to the subject matter of the workbook.
Author is initially the name specified in the General tab of the Options dialog box, which appears from the Options command from the Tools menu. If this is omitted, the registered user of the copy of Microsoft Excel will be used.
Keywords are keywords that can be later used in searching for the contents in the file.
Comments is a comment that can be entered to help a user learn more about the contents or subject matter of the workbook.
Related Functions
FIND.FILE Lets you search for files based on criteria such as author or creation date
GET.WORKBOOK Returns information about a workbook document
List of Command-Equivalent Functions