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:
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 *
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.
=ASAPFILEPROPERTIES("Last Print Date")
property_name_or_id = The id or English name of the built-in document property
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext