Equivalent to clicking the Properties command on 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 on the Summary tab of the Properties dialog box. 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 User Name box on the General tab in 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 sheet
Return to index