Here is a simple VBA code to "Kill" the Excel process using VBA
Sub Kill_Excel()
Dim sKillExcel As String
sKillExcel = "TASKKILL /F /IM Excel.exe"
Shell sKillExcel, vbHide
End Sub
Wednesday, May 06, 2009
Download Windows Live Toolbar and personalize your Web experience! Add custom buttons to get the information you care about most.
Most excellent! Thank you very much!!
ReplyDeleteIn the words of Borat,
ReplyDelete"Very Nice!"
Is it possible to stop process but never close excel workbook
ReplyDeleteIt does what the title says it does, don't expect more!
DeleteSave, close the workbook programaticly and set your object to nothing or whatever. Then kill the residual Excel.exe process. What I do not understand is why the process is still there and this kind of brute force kill is nessasary to begin with! I have removed all add ins in Excel. This seems to be a known common problem even up to Excel 201. I havent tested Excel 2013 yet.
That is strange. Once the process gets killed the Application is no more in Memory
ReplyDeleteEh. What? Is that irony?
DeleteWorks Great - Thank You.
ReplyDeleteI've been fighting with this problem for days . . . .
Thanks a lot ;) was looking for something to kill excel while running PPT VBA code.
ReplyDeleteAgain :) THANKS :))
Rami
Fantastic solution, but what if the user has other sessions of excel open that they don't want closed?
ReplyDeletedude, this is not working for me. Is it because of excel 2010 version since i can see for others it is exact solution. Please reply soon.
ReplyDeletethat code works perfectly on my Excel 2010. Shame you didn't provide any details of what "not working" means exactly.
DeleteHi
ReplyDeleteThis code kill all open excel files how to kill only one particular file