WORKBOOKPROPERTIES

WORKBOOKPROPERTIES()
Returns a particular workbook property of the active workbook.

REMARKS
Returns the value of one of the built-in document properties for the current workbook.
You can refer to document properties either by index value or by their English name.
The following list shows the available built-in index values and document property names:
1 Title
2 Subject
3 Author
4 Keywords
5 Comments
6 Template
7 Last Author
8 Revision Number
9 Application Name
10 Last Print Date
11 Creation Date
12 Last Save Time
13 Total Editing Time *
14 Number of Pages *
15 Number of Words *
16 Number of Characters *
17 Security
18 Category
19 Format
20 Manager
21 Company
22 Number of Bytes *
23 Number of Lines *
24 Number of Paragraphs *
25 Number of Slides *
26 Number of Notes *
27 Number of Hidden Slides *
28 Number of Multimedia Clips *
29 Hyperlink Base
30 Number of Characters (with spaces) *
* Excel isn't required to define values for every built-in document property.
If Microsoft Excel doesn't define a value for one of the built-in document properties, reading the Value property for that document property results in an error.
You have to press Ctrl+Alt+F9 to have the formula recalculated.

MORE FUNCTIONS
WORKBOOKFILENAME Returns the file name of the active workbook.
WORKBOOKPATH Returns the folder path (or full path) of the active workbook.
WORKSHEETNAME Returns the name of the worksheet in a given position.