1,451
社区成员
发帖
与我相关
我的任务
分享
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所导致的?'假定 wb 是你的 WorkBook 对象'
Dim i As Long
Combo1.Clear
For i = 1 To wb.Sheets.Count
Combo1.AddItem wb.Sheets(i).Name
Next