View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_489_] Simon Lloyd[_489_] is offline
external usenet poster
 
Posts: 1
Default how to get the cmd window to close in VBA??

I have written some code to open a program on a PC when a certai
condition exists, this works fine and does the job, however the cm
window is still left open after this operation anyone know how to clos
it in VBA???

Here's the code i use.....

shell("cmd /k C:\notes\notes.exe")

where notes is the program to open.


Simo

--
Message posted from http://www.ExcelForum.com