The DocumentProperties object represents properties of a spreadsheet. These properties are displayed in the file's Properties sheet which can be opened in Excel (File -> Properties), or by right-clicking the file icon and selecting "Properties." - In Excel 2003 these properties can be accessed via (File -> Properties).
- In Excel 2007 they can be accessed via (Ribbon button -> Prepare -> Properties).
- In Excel 2010 they can be accessed via (File -> Info -> Show All Properties on the right).
- In Windows Explorer, right-click on the file and select 'Properties'.
The DocumentProperties class can be used to remove personal information from an existing spreadsheet, or to populate searchable fields that can be used to locate the file. |