April 2006
Beginner
1114 pages
98h 16m
English
workbook.DocumentLibraryVersions
For workbooks that are part of a shared workspace, returns a collection containing the revision history for the workbook. For example, the following code displays revisions tracked for a workbook in a shared workspace:
Dim ver As DocumentLibraryVersion
If ThisWorkbook.SharedWorkspace.Connected Then
For Each ver In ThisWorkbook.DocumentLibraryVersions
Debug.Print ver.ModifiedBy, ver.Modified, ver.Comments
Next
End IfRead now
Unlock full access