Thread: Close Shell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
urkec urkec is offline
external usenet poster
 
Posts: 131
Default Close Shell

"CanonChris" wrote:

Can somebody tell me how to end a Windows MediaPlayer session in Excel VBA. I
have used the Shell code to open it.

Thank you in advance for your reaction.



If you don't get a better answer try this. It uses Taskkill command to kill
the wmplayer.exe process.

Sub KillWMPlayer()

Shell """C:\Program Files\Windows Media Player\wmplayer.exe"" /prefetch:1",
vbNormalFocus
Application.Wait Now + TimeValue("0:00:05")
Shell "CMD /C TASKKILL /IM wmplayer.exe"

End Sub

HTH

--
urkec