Trying to Send a Keystroke to a specific Window

[Jason Zischke]

Hi all

I trying to send a keystroke to a specific window the first command goes all
right but it doesn't send the key. Below is my code.

appactivate "Microsoft Excel - My Book.xls"
SendKeys "{ENTER}"

Jason

 

[Chip Pearson]

I would very strongly recommend that not use SendKeys, especially with an
application like Excel that supports automation. If you describe what you
need to accomplish, you will likely get a better approach that SendKeys.

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Jason Zischke]

Hi Chip

What I am trying to accomplish is I have created like a little program which
prints to another excel window that is open so that the user can keep working
while it prints so I tried sending a keystroke to that window where I have
set up an Onkey
accelerator to preform the print function on demand.

Jason