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

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" wrote in message
...
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

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

"Chip Pearson" wrote:

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" wrote in message
...
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