The value of the custom property becomes whatever is in the cell with that named range.įirst create a named range in your workbook. It is possible to link custom properties to named cells in your workbook.
#Show document properties excel windows
The property values are also looked at when you use the Windows Search functionality to search for files on your computer When you select a different file this information is automatically refreshed. This will display a panel of information on the right hand side showing you all the workbook properties. In the "Open" dialog box, click View and select Properties It is possible to see the properties of a particular workbook before opening it from the (File > Open) dialog box. Saving useful information in your workbooks using workbook properties is extremely useful especially when you are trying to find a particular workbook. Properties - Lists all the custom properties that have been created in the active presentation.Īdd - Adds the custom property to the active presentation.ĭelete - Removes the custom property from the active presentation. Link to content - Whether the custom property is linked to a specific item in the file. Value - The text or value you want to save as the custom property. Type - The type of the property, either Text, Date, Numeric or Yes / No. Name - Select or create a name for the property. It is possible to add your own custom properties and it is even possible to link these to cells. Last saved by - The user name of the person who last saved this workbook. Modified - The date the workbook was last modified.Īccessed - The date the workbook was last accessed. This is not a particularly user friendly options and selecting this will increases the size of the file.Ĭreated - The date the workbook was created.
Save preview picture - Saves a picture of the first page of the file for previewing in the New dialog box.
This can be an Internet address, a path to a folder on your hard disk, or a path to a folder on a network. Hyperlink base - Type the path or URL that you want to use for all hyperlinks with the same base address that are inserted in the current document. The other properties can be used to group similar files together, so you can search for files that have specific properties. Use this property to group similar files together, so you can search for all files that have the same subject. The title can be different from the file name. Title - Type the title you want to use when searching for this file. Location - The folder location of the Excel workbook. This is always Microsoft Excel Worksheet. These properties can be extremely useful when you are searching for files. It is possible to add useful information to an active workbook such as the author, title or additional comments. You can associate an enormous range of information with an individual workbook (File > Properties). This can be very useful when you have to manage a large number of files. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.You can use this information to then search for specific files. rw = 1įor Each p In ActiveWorkbook.CustomDocumentProperties This example displays the names and values of the custom document properties as a list on worksheet one. Properties of type msoPropertyTypeString ( MsoDocProperties) cannot exceed 255 characters in length. Use the BuiltinDocumentProperties property to return the collection of built-in document properties. CustomDocumentProperties.Item("Complete") Use the Item method to return a single member of the collection (a DocumentProperty object) by specifying either the name of the property or the collection index (as a number).īecause the Item method is the default method for the DocumentProperties collection, the following statements are identical. This property returns the entire collection of custom document properties. SyntaxĮxpression A variable that represents a Workbook object. Returns or sets a DocumentProperties collection that represents all the custom document properties for the specified workbook.
0 kommentar(er)
