View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andr? Palmela Andr? Palmela is offline
external usenet poster
 
Posts: 2
Default [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