Posted to microsoft.public.excel.programming
|
|
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
|