WorkbookBase.RemoveDocumentInformation(XlRemoveDocInfoType) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Removes all information of the specified type from the workbook.

public void RemoveDocumentInformation (Microsoft.Office.Interop.Excel.XlRemoveDocInfoType removeDocInfoType);

Parameters

removeDocInfoType: XlRemoveDocInfoType

One of the Microsoft.Office.Interop.Excel.XlRemoveDocInfoType values that specifies the type of information to be removed.

Examples

The following code example removes all the workbook properties of the current workbook.

This example is for a document-level customization.

private void RemoveWorkbookProperties()
{
    this.RemoveDocumentInformation(
        Excel.XlRemoveDocInfoType.xlRDIDocumentProperties);
}

Private Sub RemoveWorkbookProperties()
    Me.RemoveDocumentInformation( _
        Excel.XlRemoveDocInfoType.xlRDIDocumentProperties)
End Sub

Applies to