-
I have just converted a program, to input data from a text file into excell. The old method was DDE and the new method I am using is Automation. The problem I am having is that each time I open an instance of excell it will not close even after I declare the excell object to nothing. I have tried tips from Microsofts database but I cannot get the Excell object to close. Any tips or help would be appreciated.
-
When you set a variable to nothing, all it does is dumps the reference to the excel object, but keeps the process itself running. When using automation you should use the objects destructors or cleanup functions.
for excel it is
excelApp.Close
-
I actually use objExcell.application.quit
set objExcell = nothing
objExcell.application.close is not allowed