Automating Document Inspection

The new document inspection capabilities in Excel 2007 can also be a good thing. In previous versions of Office, it was very easy to release sensitive information accidentally hidden in a workbook with other data intended for release.

The Document Inspector, covered in the previous section, provides a manual method to remove this type of information. If you are faced with processing a large number of workbooks, however, you need an automated solution. This solution is provided by the new RemoveDocumentInformation method and DocumentInspectors collection of the Workbook object in Excel 2007. These two features somewhat arbitrarily divide the Document Inspector sections into two groups with different capabilities for each, as described in the following sections.

Note that like the Document Inspector user interface, the RemoveDocument Information method, and the DocumentInspectors collection can only operate on open workbooks with all worksheets unprotected.

0 0

Post a comment