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 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")