asked on
Kill excel process on Windows 8 server
Hi,
I have a windows 8 server on which I have created 5 users to login with credentials.
Some times I need to close all the excel process running on all the 5 users and i created a vb script for it .
My script kill only the excel process only on the user I executed the script on remaining other users excel process is still running and not get killed.
Please suggest
I am using below script:
KillprocessIE ="EXCEL.EXE"
Set ProcessList2 = GetObject("winmgmts://.").
For Each Process In ProcessList2
If Process.Name = KillProcessIE Then
Process.Terminate
End If
Next
Msgbox "All Excel Processes in your session have been terminated successfully"
I have a windows 8 server on which I have created 5 users to login with credentials.
Some times I need to close all the excel process running on all the 5 users and i created a vb script for it .
My script kill only the excel process only on the user I executed the script on remaining other users excel process is still running and not get killed.
Please suggest
I am using below script:
KillprocessIE ="EXCEL.EXE"
Set ProcessList2 = GetObject("winmgmts://.").
For Each Process In ProcessList2
If Process.Name = KillProcessIE Then
Process.Terminate
End If
Next
Msgbox "All Excel Processes in your session have been terminated successfully"
Windows OSWindows XPMicrosoft Legacy OS
Last Comment
Qlemo
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Any reason why you do not start taskkill directly? Using SendKeys isn't an approach you should favour.
Using your inputs I have modofied my code as:
Set oshell = createobject("Wscript.Shel
oshell.run"cmd.exe"
wscript.sleep 500
oshell.sendkeys "Taskkill /f /im excel.exe"""+("{Enter}")
wscript.sleep 5000
oshell.sendkeys "exit"+("{Enter}")
set oshell = nothing
WScript.Quit