Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Close External Apps Issue
I coded this macro to close two external applications when activated.
The macro was working perfectly fine before but now it fails to send the SendKeys properly and neither application closes. I don't know if it is an issue with the coding or due to computer related issues. The code I used is: Sub CloseApp() AppActivate "X" SendKeys "%{F4}" Application.Wait (Now + TimeValue("0:00:01")) SendKeys "~" Application.Wait (Now + TimeValue("0:00:05")) AppActivate "Y" Application.Wait (Now + TimeValue("0:00:01")) SendKeys "%{F4}" End Sub Substituted "X" and "Y" for the actual app names. Thanks for your help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - Alt-E hotkey does not work in MSOffice apps, no prob in other apps | Excel Discussion (Misc queries) | |||
Issue on Close Q | Excel Programming | |||
Excel closes all open apps when i close one | Excel Discussion (Misc queries) | |||
Is Controlling External Apps with Excel VBA possible? | Excel Programming | |||
After OpenText all pastes from external apps use format from OpenText | Excel Programming |