Killing Ghost Excel processes

[zealot777]

Hi,
I am running a macro in Matlab which leaves the 5 ghosts excel.exe processes running after each macro loop - I have 168 loops - so it builds up a lot.I wanted to ask if there is a way to close all instances of excel.exe - other than the active master workbook from which the macros are running?Or excel processes can be differentiated by size (less than 100 lbs) or less than minute older.
Thanks a hope it is possible!
Dave

 

[Norie]

Dave

Have you checked why you are ending up with ghost processes?

 

[zealot777]

Dave

Have you checked why you are ending up with ghost processes?

thanks =- Ihave been offered this explanation but it does nto help - none of the addons seems to affect this:

https://uk.mathworks.com/matlabcent...-using-xlsread-xlswrite-or-xlsfinfo-in-matlab


One way to work around this issue is to identify the application that is causing this issue, then disable it. You can also contact the company which created the software to notify them of this issue.

 

[Norie]

Dave

I can post some Powershell code to kill all Excel processes, is that the sort of thing you are looking for?

 

[zealot777]

Dave

I can post some Powershell code to kill all Excel processes, is that the sort of thing you are looking for?

sweet - can i envoke this code from vba? and kill only processes smaller than 100 mbs? that woudl be perfect!

 

[zealot777]

sweet - can i envoke this code from vba? and kill only processes smaller than 100 mbs? that woudl be perfect!

any ideas?

 

[Norie]

Sorry, not had time to reply - actually thought I had some code kicking about but I can't find it.

I'll try and post something later.

 

[zealot777]

Sorry, not had time to reply - actually thought I had some code kicking about but I can't find it.

I'll try and post something later.

thank you - will wait for it)

 

[Norie]

Here's PowerShell code that will kill any Excel processes that are using less than 10MB.

$processes_to_kill = get-process |

    where { $_.PM -le 10MB  -and $_.path -like "*excel.exe"}

if ($processes_to_kill -ne $null)

{

    $processes_to_kill | foreach { $_.Kill() }

}