ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sendkeys and active windows (https://www.excelbanter.com/excel-programming/312913-sendkeys-active-windows.html)

Peter Yeoh

Sendkeys and active windows
 
I have a macro that uses SendKeys to send ALT-W to an application, which
will open a new application. On Windows 2000, this new application
automatically becomes active, and any subsequent SendKeys command will be
directed to it. On Windows XP, this new application does not become active.
It's title bar flashes to notify that a new window has been created, but the
active application is still the previous one (which I sent the ALT-W command
to). This happens with both Excel 2000 and XP.

Is there a workaround to this? I would like the new application to become
active immediately. Thanks in advance.

--
Peter Yeoh





All times are GMT +1. The time now is 09:15 PM.

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