Private Sub Command5_Click() Dim eApp As New Excel.Application Dim xlsFile As String xlsFile = Dir("c:\*.xls") Do While xlsFile <> "" xlsFile = "c:\" & xlsFile eApp.Workbooks.Open xlsFile xlsFile = Dir() Loop eApp.Visible = True Set eApp = Nothing End Sub 打开c:\目录下的xls文件(不包括子目录里的)
Dim eApp As New Excel.Application
Dim xlsFile As String
xlsFile = Dir("c:\*.xls")
Do While xlsFile <> ""
xlsFile = "c:\" & xlsFile
eApp.Workbooks.Open xlsFile
xlsFile = Dir()
Loop
eApp.Visible = True
Set eApp = Nothing
End Sub
打开c:\目录下的xls文件(不包括子目录里的)