Close a program

[Tiger99]

Hi
I am using createObject() method to open a program. When the program stop running, to close the program, I need to click on any key. Is there a way to use VBA to automate this process?

Thanks for you help

 

[earlyd]

Do you mean close the workbook? ActiveWorkbook.close.

 

[litrelord]

Hi,

have you tried using the quit command?

eg. if you have called the object MyProg then MyProg.Quit

Nick

 

[Ivan F Moala]

Hi
I am using createObject() method to open a program. When the program stop running, to close the program, I need to click on any key. Is there a way to use VBA to automate this process?

Thanks for you help

You need to Call the Objects quit function....ie If Excel then

MyObject.Quit

what is the Syntax for your Programs Quit/Close