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