Workbook.SyncEvent 事件 (2007 system)

更新:2007 年 11 月

在属于文档工作区的工作表的本地副本与服务器上的副本进行同步时发生。

命名空间:  Microsoft.Office.Tools.Excel
程序集:  Microsoft.Office.Tools.Excel.v9.0(在 Microsoft.Office.Tools.Excel.v9.0.dll 中)

语法

声明
Public Event SyncEvent As WorkbookEvents_SyncEventHandler
用法
Dim instance As Workbook
Dim handler As WorkbookEvents_SyncEventHandler

AddHandler instance.SyncEvent, handler
public event WorkbookEvents_SyncEventHandler SyncEvent

示例

下面的代码示例演示 SyncEvent 事件的处理程序。该事件处理程序在文档工作区中的工作表同步失败时显示一条消息。

此示例针对的是文档级自定义项。

Sub ThisWorkbook_SyncEvent( _
    ByVal SyncEventType As Office.MsoSyncEventType) _
    Handles Me.SyncEvent

    If SyncEventType = _
        Office.MsoSyncEventType.msoSyncEventDownloadFailed OrElse _
        SyncEventType = Office.MsoSyncEventType.msoSyncEventUploadFailed Then
        MsgBox("Document synchronization failed.")
    End If
End Sub
private void WorkbookSyncEvent()
{
    this.SyncEvent +=
        new Excel.WorkbookEvents_SyncEventHandler(
        ThisWorkbook_SyncEvent);
}

void ThisWorkbook_SyncEvent(Office.MsoSyncEventType SyncEventType)
{
    if (SyncEventType == Office.MsoSyncEventType.msoSyncEventDownloadFailed ||
        SyncEventType == Office.MsoSyncEventType.msoSyncEventUploadFailed)
    {
        MessageBox.Show("Document synchronization failed.");
    }
}

权限

另请参见

参考

Workbook 类

Workbook 成员

Microsoft.Office.Tools.Excel 命名空间