EXCEL问题,48小时内给分!!!
在一个按钮中有以下程序:
Dim xlApp As Object
Dim xlWorkBook As Object
Dim xlSheet As Object 'New Excel.Worksheet
Dim i As Long
Set xlApp = CreateObject("Excel.Application")
Set xlWorkBook = xlApp.Workbooks.Add
Set xlSheet = xlWorkBook.Sheets.Add
。。。。。
最后用了
xlApp.Visible = True
Set xlWorkBook = Nothing
Set xlSheet = Nothing
Set xlApp = Nothing
可是我发现每点一次该按钮就会在win2000中开一个叫EXCEL进程(我已经把弹出的EXCEL关闭了,但进程还在),就是说Set XX=nothing没把它们结束!何解???
多谢各位,UP也给分