topic RE: kill excel instance in Product Forum

kill excel instance

PratikshaTiwari — Mon, 06 Sep 2021 04:02:00 GMT

I am trying to Kill excel instance by its Process Name with Kill Process Action but seems i am failing to do so . Even after killing the instance the file says it is locked by user ?

------------------------------
Pratiksha Tiwari
------------------------------

RE: kill excel instance

EVIPUTI — Mon, 06 Sep 2021 04:18:00 GMT

The best way is to use MS Excel VBO and use the Exit and Close Instances actions. One can also use close all instances.

For kill instance simply try "EXCEL" !

------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------

RE: kill excel instance

sumire — Tue, 07 Sep 2021 00:59:00 GMT

Hi,

The "Kill Process" included in the "Utility - Environment" VBO is not able to completely kill the process.
https://docs.microsoft.com/en-us/dotnet/api/system.diagnostics.process.kill?view=netframework-4.8

So I created an object to completely kill using code stage.
Input: ProcessName(text)
Output: nothing

Dim p As New System.Diagnostics.Process()

p.StartInfo.FileName = System.Environment.GetEnvironmentVariable("ComSpec")

p.StartInfo.Arguments = "/c taskkill /F /T /FI ""username eq %USERNAME%"" /IM " & ProcessName

p.StartInfo.UseShellExecute = false
p.StartInfo.CreateNoWindow = true

p.Start()
p.WaitForExit()
p.Close()

You can kill Excel processes completely by giving "EXCEL.EXE" as the input argument "ProcessName".

------------------------------
Mitsuko
Asia/Tokyo
------------------------------

RE: kill excel instance

EVIPUTI — Tue, 07 Sep 2021 04:49:00 GMT

@sumire This is useful , thanks for sharing.

------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------

RE: kill excel instance

VedSengupta — Sat, 11 Sep 2021 04:26:00 GMT

Hello Pratiksha,
Why not use close all instance action of MS Excel VBO?

------------------------------
------------------------------
Best Regards,
Ved Sengupta
RPA Developer
Deloitte India (Offices of the US)
Bangalore | INDIA
------------------------------
------------------------------