Sendkey not working

[Ben]

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



--

 

[Tom Hutchins]

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

 

[John Bundy]

I think this is what you want
Application.SendKeys "%(FEE)"

 

[Ben]

Hi Tom,

Thanks for your suggestions. It works now.

Ben

 

[Ben]

Thanks John.

Ben

--

I think this is what you want
Application.SendKeys "%(FEE)"