[RESOLVED] VBA Code SHELL Not Working

[Khadafi]

Hi, i am using the following code to close down an .exe program.

Dim sKillMagnify As String	
sKillMagnify = "TASKKILL /F /IM Magnify.exe"	
Shell sKillMagnify, vbHide

I used the code in powerpoint in vista and it worked perfectly, but when i am using the code in XP i get an error on

Shell sKillMagnify, vbHide

saying Run-time error '53': File not found.

Thanks.

[RobDog888]

Taskkill.exe and magnify.exe both are located in the system32 directory under XP. Perhaps verifying the directory path is correct that you are passing at runtime.

[Khadafi]

Hi, could you please explain further, i didnt quite understand your post.
Thank you.

[RobDog888]

Place a breakpoint on on "Shell sKillMagnify, vbHide" and see what the value of sKillMagnify is. It may not be the value you expect.

[Khadafi]

Hi, what do you mean by place a breakpoint.

The exact code works perfectly on powerpoint in windows vista, but it is not working on xp so i know there is nothing wrong with the code.

thanks

[RobDog888]

Well as I was saying you can not assume the code will workon different operating systems.

In the IDE, place your cursor on the line of code to stop execution on for debugging. Then press F9. A red line will appear. Run your code and when it stops at that line. Check the value of the variable.

[westconn1]

so i know there is nothing wrong with the code.

as there is nothing wrong with the code it must be working fine

you may need to provide full paths to boh the files like
c:\windows\sysem32\taskill.exe

[Mr.Cool]

Try This Out:

Dim Error
strComputer = "<Replace With Your Local Machine Name Or Remote server Name>"
Set objWMIService = GetObject _
("winmgmts:\\" & strComputer & "\root\cimv2:Win32_Process")

Error = objWMIService.Create("<Replace with Name Of Process You Want To Execute>", Null, Null, intProcessID)

If Error = 0 Then
MsgBox "Process was started with a process ID of " _
& intProcessID & "."
Else
MsgBox "Process could not be executed due to error " & _
Error & "."
End If

Ensure that the process which you want to trigger it's exe file must exist on System32 (c:\windows\system32) Folder

[Khadafi]

Hi, the original code is working on another XP machine, so i know the code is working fine on both XP and Vista. I'll just use the other xp machine.
Thanks for all the help

[RobDog888]

If it works on one XP and not another XP then are both accouts the same?
If this issue is settled then please dont forget to use the thread tools and select Mark Thread as Resolved so others know its done

[Khadafi]

It is only working on one XP, I don't understand why it dosn't work on the other XP computer, but it's not a problem.
Thanks For All The Help.

[Pilm]

The reason it didn't work on Khadafi's other XP PC is b/c that PC didn't have taskkill.exe in system32 directory.