Share via

Sync.WorkspaceLastChangedBy Property

  • Article
Office Developer Reference

Displays the display name of the user who last saved changes to the server copy of a shared document. Read-only.

Syntax

expression.WorkspaceLastChangedBy

expression   A variable that represents a Sync object.

Remarks

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.

Example
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.

Visual Basic for Applications 
      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

See Also