ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   App activate issue (https://www.excelbanter.com/excel-worksheet-functions/238086-app-activate-issue.html)

sunspot27

App activate issue
 
I'm using the following code to access an application called ACT! that
is open and running and send the following keys. However after the
'AppActivate' line, it reverts back to excel.

Sub test()

AppActivate ("ACT!")
SendKeys ("%f")
SendKeys ("d")
SendKeys ("e")

End Sub


How do i stop this form happening?

Thanks


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com