Visual basic-检查ActiveWorkbook.Save()是否成功

Question

如何检查此保存命令是否成功？

Dim objExcel As New Microsoft.Office.Interop.Excel.Application
Public Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
  objExcel.ActiveWorkbook.Save()
End Sub

例如，当程序在远程excel工作簿中工作时，连接断开。

Answer 1

制定了一个变通方法。在更新之前，会存储最后一个Excel行号，然后在更新之后，我也会存储该行号。

objWorkbook = objExcel.Workbooks.Open("C:filename.xlsx")
objSheet = objWorkbook.Worksheets("Sheet1")
lRow = objSheet.Cells.Find("*", SearchOrder:=Excel.XlSearchOrder.xlByRows, SearchDirection:=Excel.XlSearchDirection.xlPrevious).Row + 1
beforeUpdate = lRow
'updating happens
objSheet.Cells(lRow, 1).value = TextBox1.Text
'finding the last available row again
lRow = objSheet.Cells.Find("*", SearchOrder:=Excel.XlSearchOrder.xlByRows, SearchDirection:=Excel.XlSearchDirection.xlPrevious).Row + 1
afterUpdate = lRow
If beforeUpdate < afterUpdate Then
  MessageBox.Show("Successful update.")
Else
  MessageBox.Show("The update was unsuccessful!")
End If

这个解决方法适合我。