RevisionNumber Property

Applies To

Workbook Object.

Description

Returns the number of times the workbook has been saved while open as a shared list. If the workbook is open in exclusive mode, this property returns 0 (zero). This property is available only in Microsoft Excel for Windows 95. Read-only.

Remarks

The RevisionNumber property is updated only when the local copy of the workbook is saved, not when remote copies are saved.

See Also

MultiUserEditing Property, SaveAs Method.

Example

This example uses the revision number to determine whether the active workbook is open in exclusive mode. If it is, the example saves the active workbook as a shared list.

If ActiveWorkbook.RevisionNumber = 0 then
    ActiveWorkbook.SaveAs filename := ActiveWorkbook.FullName, _
        accessMode:= xlShared, conflictResolution := _
        xlOtherSessionChanges
End If

This example displays the revision number of the active workbook.

MsgBox ActiveWorkbook.RevisionNumber