Workbook.RemoveDocumentInformation Method

Excel Developer Reference

Removes all information of the specified type from the workbook.

Version Information
 Version Added:  Excel 2007

Syntax

expression.RemoveDocumentInformation(RemoveDocInfoType)

expression   A variable that represents a Workbook object.

Parameters

Name Required/Optional Data Type Description
RemoveDocInfoType Required XlRemoveDocInfoType Type of information to be removed.

Remarks

The following table lists the XlRemoveDocInfoType constants

  • xlRDIAll
  • xlRDIComment
  • xlRDIContentType
  • xlRDIDefinedNameComments
  • xlRDIDocumentManagementPolicy
  • xlRDIDocumentProperties
  • xlRDIDocumentServerProperties
  • xlRDIDocumentWorkspace
  • xlRDIEmailHeader
  • xlRDIInactiveDataConnections
  • xlRDIInkAnnotations
  • xlRDIlPublishInfo
  • xlRDIRemovePersonalInformation
  • xlRDIRoutingSlip
  • xlRDIScenarioComments
  • xlRDISendForReview

See Also