Sendkey not working
 

Hi all,

Sendkey doesn't seem to be working correctly, I want it to do alt, F, E, E.
But when executing the code, it executed alt, F then the "File" loses the
highlight. Any thoughts?


Thanks,

Ben



--

Sendkey not working
 

What commands are you trying to execute with the two E's? I'm using Excel
2003, and nothing in my File menu has a shortcut of E. Check what letter is
underlined for the command you want to execute in the File menu.

Hope this helps,

Hutch

"Ben" wrote:


Hi all,

Sendkey doesn't seem to be working correctly, I want it to do alt, F, E, E.
But when executing the code, it executed alt, F then the "File" loses the
highlight. Any thoughts?


Thanks,

Ben



--

Sendkey not working
 

I think this is what you want
Application.SendKeys "%(FEE)"
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Ben" wrote:


Hi all,

Sendkey doesn't seem to be working correctly, I want it to do alt, F, E, E.
But when executing the code, it executed alt, F then the "File" loses the
highlight. Any thoughts?


Thanks,

Ben



--

Sendkey not working
 

Hi Tom,

Thanks for your suggestions. It works now.

Ben

--



"Tom Hutchins" wrote:

What commands are you trying to execute with the two E's? I'm using Excel
2003, and nothing in my File menu has a shortcut of E. Check what letter is
underlined for the command you want to execute in the File menu.

Hope this helps,

Hutch

"Ben" wrote:


Hi all,

Sendkey doesn't seem to be working correctly, I want it to do alt, F, E, E.
But when executing the code, it executed alt, F then the "File" loses the
highlight. Any thoughts?


Thanks,

Ben



--

Sendkey not working
 

Thanks John.

Ben

--



"John Bundy" wrote:

I think this is what you want
Application.SendKeys "%(FEE)"
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Ben" wrote:


Hi all,

Sendkey doesn't seem to be working correctly, I want it to do alt, F, E, E.
But when executing the code, it executed alt, F then the "File" loses the
highlight. Any thoughts?


Thanks,

Ben



--