1、获取Excel工作薄所有Sheet表名称、Sheet表的个数、删除指定Sheet表:
'先引用对象库:Microsoft Excel 11.0 Object Library
Option Explicit
Dim xlExcel As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Private Sub Command1_Click()
On Error GoTo Errhandler
CommonDialog1.Filter = "Excel(*.xls)|*.xls|AllFile(*.*)|*.*"
CommonDialog1.FilterIndex = 1
CommonDialog1.ShowOpen
Set xlExcel = New Excel.Application
xlExcel.Workbooks.Open CommonDialog1.FileName
Set xlBook = xlExcel.Workbooks(CommonDialog1.FileTitle)
Application.Visible = False
Application.DisplayAlerts = False '不提示保存对话框
Debug.Print xlBook.Worksheets.Count 'Sheet表的个数
For Each xlSheet In xlBook.Worksheets
Set xlSheet = xlBook.Worksheets(xlSheet.Name)
Debug.Print xlSheet.Name '列出所有Sheet表
If xl