vb 检测 sheet是否存在

来源:百度知道 编辑:UC知道 时间:2024/06/08 09:43:24
Dim Strsource As String
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Strsource = App.path & "\数据表.xls"
Set xlApp = CreateObject("Excel.application")
Set xlBook = xlApp.Workbooks.open(Strsource)

if "数据表中 表格123 的sheet 不存在 then
xlbook.sheets.add
xlapp.activesheet.name="表格123"
end if
Set xlSheet = xlBook.Worksheets("表格123")

等待高手解决,怎么判断excel中表格是否存在?

Dim Strsource As String
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Strsource = App.path & "\数据表.xls"
Set xlApp = CreateObject("Excel.application")
Set xlBook = xlApp.Workbooks.open(Strsource)

Dim isExistSheet As Boolean
isExistSheet = False
For Each xlSheet In xlBook.Worksheets
If xlSheet.Name = "表格123" Then
isExistSheet = True
Exit For
End If
Next

if not isExistSheet then
xlbook.sheets.add
xlapp.activesheet.name="表格123"
end if
Set xlSheet = xlBook.Worksheets("表格123")