Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[HELP] closing a program with VBA code
Hello
I need help for closing an aplication in the end of an Excel Sub() I tried the code: ------------------------------------------------------------------- AppActivate "IML Device 1", False SendKeys "%{F4}", False DoEvents AppActivate "IML Device 1", False DoEvents SendKeys "ENTER", False DoEvents -------------------------------------------------------------------- i will have to send the ALT+F4 command to close and then press "enter" because it is one of those programs that ask if you "really whant to close" ... The problem is that the "ENTER" comand i send it's not making anything... The program remains with the question that "do you really what to close" and does not close. Any ideia for resolving this problem ? I already made searches over the internet and i didn't find the answer. Thank You Regards André Palmela |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
[HELP] closing a program with VBA code
try putting all the keystrokes in one line. This should put them in the
keyboard buffer for that program and it will process them as it needs them. AppActivate "IML Device 1", False SendKeys "%{F4}~", False DoEvents -- Regards, Tom Ogilvy "Andr? Palmela" wrote in message m... Hello I need help for closing an aplication in the end of an Excel Sub() I tried the code: ------------------------------------------------------------------- AppActivate "IML Device 1", False SendKeys "%{F4}", False DoEvents AppActivate "IML Device 1", False DoEvents SendKeys "ENTER", False DoEvents -------------------------------------------------------------------- i will have to send the ALT+F4 command to close and then press "enter" because it is one of those programs that ask if you "really whant to close" ... The problem is that the "ENTER" comand i send it's not making anything... The program remains with the question that "do you really what to close" and does not close. Any ideia for resolving this problem ? I already made searches over the internet and i didn't find the answer. Thank You Regards André Palmela |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping program open even when closing workbook | Excel Discussion (Misc queries) | |||
Excel program remains open after closing file | Excel Discussion (Misc queries) | |||
How can I exit a workbook in Excel without closing the program? | Excel Discussion (Misc queries) | |||
How do I save personal menu bar settings when closing program | Setting up and Configuration of Excel | |||
Need program to ask me to save changes when closing | Excel Programming |