Displays the display name of the user who last saved changes to the server copy of a shared document. Read-only.
Note Beginning with Microsoft Office 2010, this object or member has been deprecated and should not be used.
expression. WorkspaceLastChangedBy
expression A variable that represents a Sync object.
If the active document is not configured for synchronization between the local copy and the server copy, the WorkspaceLastChangedBy property raises a run-time error.
The following example checks for a conflict between the local and the server copies of the shared document and reports the name of the user who last saved changes to the server copy.
Dim objSync As Office.Sync
Dim strStatus As String
Set objSync = ActiveDocument.Sync
If objSync.Status = msoSyncStatusConflict Then
strStatus = "The server copy has been changed." & vbCrLf & _
"Changes have been made by: " & _
objSync.WorkspaceLastChangedBy
MsgBox strStatus, vbInformation + vbOKOnly, "Server Copy Changed"
End If
Set objSync = Nothing