Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim oAdd As Object
Dim bResult As Boolean
'获取Excel服务器编程接口 Set oAdd = Application.COMAddIns("ESClient.Connect").Object
'如果光标跳转到C3单元格
If Target.Address = "$C$3" Then
'保存当前报表,不弹出保存对话框,但成功后询问是否填报下一张
bResult = oAdd.saveCase(, True, True)
If bResult = False Then
'若保存失败,提示
MsgBox "保存失败!"
Else
'保存成功,光标自动跳转到C2,等待输入下一张
Range("C2").Select
End If
End If