Edit

Share via

Sync.WorkspaceLastChangedBy property (Office)

  • Article

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.

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.

    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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.