WorkbookSync Event [Excel 2003 VBA Language Reference]

  • Article

Occurs when the local copy of a workbook that is part of a Document Workspace is synchronized with the copy on the server.

Private Subobject_WorkbookSync(Wb, SyncEventType)

object An object of type Workbook declared by using the WithEvents keyword in a class module.

Wb   Workbook. The workbook being synchronized.

MsoSyncEventType

MsoSyncEventType can be one of the following msoSyncEventType constants:

msoSyncEventDownloadFailed
msoSyncEventDownloadInitiated
msoSyncEventDownloadNoChange
msoSyncEventDownloadSucceeded
msoSyncEventOffline
msoSyncEventUploadFailed
msoSyncEventUploadInitiated
msoSyncEventUploadSucceeded

Example

The following example displays a message if the synchronization of a workbook in a Document Workspace fails.

Private Sub app_WorkbookSync(ByVal Wb As Workbook, _
        ByVal SyncEventType As Office.MsoSyncEventType)
    
    If SyncEventType = msoSyncEventDownloadFailed Or _
            SyncEventType = msoSyncEventUploadFailed Then
            
        MsgBox "Workbook synchronization failed. " & _
            "Please contact your administrator " & vbCrLf & _
            "or try again later."
    
    End If

End Sub

Applies to | Application Object