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