如何删除excel中的工作表?
我用如下代码想删除excel中的“数量汇总”表失败,听到“嘀”的一声后弹出个保存副本的窗体。
Dim oXlsApp As Excel.Application
Dim oXlsWorkBook As Excel.Workbook
Dim SlWorkSheet As Excel.Worksheet
Dim lcindex As Integer
Set oXlsApp = New Excel.Application
Set oXlsWorkBook = oXlsApp.Workbooks.Open(sFileName)
oXlsWorkBook.Worksheets("数量汇总").Delete
oXlsWorkBook.Close (True)
oXlsApp.Quit
Set oXlsWorkBook = Nothing
Set oXlsApp = Nothing