Dim xlApp As Excel.Application Dim xlBook As Excel.WorkbookSet xlApp = New Excel.Application Set xlBook = xlApp.Workbooks.Open(strfile) 其中strfile为文件名,每次都出现部件挂起的现象
set xlApp = New Excel.Application Set xlBook = xlApp.Workbooks.Open(strfile)
set xlApp = New Excel.Application
我的也有set,应该不是这而的问题
你是啥操作系统呀?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文件都不会出现那问题呢,同时打开8个Set eApp = Nothing这一句你一定也有咯
SET xlBook =Nothing这一句也不能省
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 利用这个代码还是出现同样的问题:“由于其它程序忙不能执行该操作”,当我重试几次后,就能打开。
Dim xlBook As Excel.WorkbookSet
xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Open(strfile)
其中strfile为文件名,每次都出现部件挂起的现象
Set xlBook = xlApp.Workbooks.Open(strfile)
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文件都不会出现那问题呢,同时打开8个Set eApp = Nothing这一句你一定也有咯
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
利用这个代码还是出现同样的问题:“由于其它程序忙不能执行该操作”,当我重试几次后,就能打开。