ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Send keystokes to different application (https://www.excelbanter.com/excel-programming/377201-send-keystokes-different-application.html)

Harley

Send keystokes to different application
 
Is it possible to code keystrokes to a different application? Do I need to
use focus commands? Is there some better method in vba to use? If it's
possible, an example would be great. NT & XL97.

JLGWhiz

Send keystokes to different application
 
It is not very practical to use keystrokes across applications. I don't know
that it is even possible with VBA. Without some description of what you hope
to accomplish, it is difficult to offer an alternative method.

"Harley" wrote:

Is it possible to code keystrokes to a different application? Do I need to
use focus commands? Is there some better method in vba to use? If it's
possible, an example would be great. NT & XL97.


Gary''s Student

Send keystokes to different application
 
Use SendKeys:

http://msdn.microsoft.com/library/de...56c24affdd.asp

--
Gary's Student


"Harley" wrote:

Is it possible to code keystrokes to a different application? Do I need to
use focus commands? Is there some better method in vba to use? If it's
possible, an example would be great. NT & XL97.



All times are GMT +1. The time now is 01:30 AM.

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