View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Close External Application using VBA

Does this help?

http://google.com/groups?selm=e5U8T%...GP12.phx. gbl

--

Vasant


"ZABU" wrote in message
...
I have a workbook that uses the shell() command to open an external
executable program and performs a database search using the external
program. The external program then dumps the data from the search into

an
excel spreadsheet. This task is executed about 30 times. Each time a new
search is performed, a new program window is opened. So after the 30
searches are complete and the data is transferred, I have to close the 30
windows.

Does anyone know how to close the external program window with VBA
code...somthing like application quite?? Any example code would be

helpful.

Regards,

ZABU