topic Re: How To Kill "Excel.exe" Process by Macro in QlikView

How To Kill "Excel.exe" Process by Macro

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to kill "EXCEL.EXE" Process by Macro.

Could you pelase share VB Script (.VBS).

Thanks,

Nihhal.

Re: How To Kill "Excel.exe" Process by Macro

marcus_sommer — Fri, 18 Nov 2016 14:50:09 GMT

If possible try to terminate this process before (after excel finished the task to which it was created). If you really need to go further with this approach take a look here: Re: How to create kill QV task which you could adapt from qlik to excel.

- Marcus

Re: How To Kill "Excel.exe" Process by Macro

Frank_Hartmann — Fri, 18 Nov 2016 15:12:40 GMT

I think this should terminate the EXCEL.EXE:

Sub TerminateProcess
Dim Process 
For Each Process In GetObject("winmgmts:").ExecQuery("Select Name from Win32_Process Where Name = 'EXCEL.EXE'")
   Process.Terminate
Next
End Sub

hope this helps!

Re: How To Kill "Excel.exe" Process by Macro

nihhalmca — Mon, 21 Nov 2016 07:52:59 GMT

Thank you.

'1) User Define Function in VBS

Sub TerminateProcess

Dim Process

For Each Process In GetObject("winmgmts:").ExecQuery("Select Name from Win32_Process Where Name = 'EXCEL.EXE'")

Process.Terminate

End Sub

'2) Call when yoiu required for end process

TerminateProcess

Note : it will lost all un saved data