Unable to terminate instance of EXCEL
Posted on 2011-10-25
I am running a procedure that updates workbooks from Excel.
After I save and close the workbook, I execute the following to terminate the instance of Excel:
On Error Resume Next
xlsApp.DisplayAlerts = False
Set xlsApp = Nothing
On Error GoTo 0
On Error GoTo ErrorHandler
I watch my Task Manager display as each of the above commands execute. There is only one instance of Excel in the stack, and nothing changes.
This is more than a little annoyance for me. I have another procedure which is trying to create an ADO connection object to an Excel workbook, and it won't work if there's an instance of Excel running.
How do I kill this beast?