引用excel,编写如下代码:Dim XlApp As New Excel.Application Dim XLWorkBook As New Excel.Workbook Set XLWorkBook = XlApp.Workbooks.Open("你的excel文档路径文件名.xls") For i = 1 To XLWorkBook.Worksheets.Count combo1.AddItem XLWorkBook.Sheets(i).Name Next XlApp.Quit
'假定 wb 是你的 WorkBook 对象' Dim i As Long Combo1.Clear For i = 1 To wb.Sheets.Count Combo1.AddItem wb.Sheets(i).Name Next
我的代码是: Private Sub Command1_Click() CommonDialog1.ShowOpen Data1.DatabaseName = CommonDialog1.FileName Frame1.Caption = CommonDialog1.FileTitle Data1.Refresh If CommonDialog1.FileName = "" Then Exit Sub Else Dim XlApp As New Excel.Application Dim XLWorkBook As New Excel.Workbook Dim i Set XLWorkBook = XlApp.Workbooks.Open(CommonDialog1.FileName) For i = 1 To XLWorkBook.Worksheets.Count Combo1.AddItem XLWorkBook.Sheets(i).Name Next XlApp.Quit End If End Sub 那是不是因为我前面使用了Data1.DatabaseName = CommonDialog1.FileName所导致的?
Dim XLWorkBook As New Excel.Workbook
Set XLWorkBook = XlApp.Workbooks.Open("你的excel文档路径文件名.xls")
For i = 1 To XLWorkBook.Worksheets.Count
combo1.AddItem XLWorkBook.Sheets(i).Name
Next
XlApp.Quit
Dim i As Long
Combo1.Clear
For i = 1 To wb.Sheets.Count
Combo1.AddItem wb.Sheets(i).Name
Next
我的代码是:
Private Sub Command1_Click()
CommonDialog1.ShowOpen
Data1.DatabaseName = CommonDialog1.FileName
Frame1.Caption = CommonDialog1.FileTitle
Data1.Refresh
If CommonDialog1.FileName = "" Then
Exit Sub
Else
Dim XlApp As New Excel.Application
Dim XLWorkBook As New Excel.Workbook
Dim i
Set XLWorkBook = XlApp.Workbooks.Open(CommonDialog1.FileName)
For i = 1 To XLWorkBook.Worksheets.Count
Combo1.AddItem XLWorkBook.Sheets(i).Name
Next
XlApp.Quit
End If
End Sub
那是不是因为我前面使用了Data1.DatabaseName = CommonDialog1.FileName所导致的?