关于excel进程的问题在通用声明里:Dim objExcel As Excel.Application在过程里:Set objExcel New Excel.
关于excel进程的问题
在通用声明里:
Dim objExcel As Excel.Application
在过程里:
Set objExcel = New Excel.Application
建立一个按钮用于关闭是:
Set objExcel = Nothing
请问这样还是关闭不了excel进程是为什么?
[解决办法]
http://download.csdn.net/detail/veron_04/2341786
[解决办法]
注意下面顺序:
- VB code
Dim xlExcel As Excel.ApplicationDim xlBook As Excel.WorkbookDim xlSheet As Excel.Worksheet................................xlBook.SavexlBook.ClosexlExcel.QuitSet xlSheet = NothingSet xlBook = NothingSet xlExcel = Nothing
