Dirty Property

True if changes have been made to the spreadsheet since the last time it was saved. Read/write Boolean.

expression.Dirty

*expression   * Required. An expression that returns a Spreadsheet object.

Example

This example exports the spreadsheet to a file if changes have been made to it since the last time it was saved.

If Spreadsheet1.Dirty Then
    Spreadsheet1.Export "sstest.xls", Spreadsheet1.Constants.ssExportActionNone
End If

Applies to | Spreadsheet Object