Printable View
Hi All,
can anyone tell me if it is possible to call a function from VBA that will kill all open occurences of Excel. I have an app that opens Excel and outputs data, however I am being left with the odd open excel process in the task manager even after Excel has been closed.
I would like to add something that looks for open Excel processes and kills them all.
Any help Appreciated.
In the absence of another reply .....
Rather than "bootstrap" a badly behaved application it would be better to change the code so that it closes down correctly.
I am not an expert with this, but have seen plenty of information on the internet about closing applications opened using code. The application is closed by using 'Quit' and the object variables removed from memory by setting them '= Nothing' in reverse order to their creation.
Many thanks for your reply Brian, I should have closed this thread as I managed to resolve the issue.
The issue was not actually with closing the Excel App but rather with closing all open objects.
thanks again.