SendKeys

[OptionTrader]

I want to switch on Caps & Number lock on opening an Excel document. I'm using the following code;

Please Login or Register  to view this content.

But nothing happens on opening. Where am I going wrong?

[royUK]

here's some code

Please Login or Register  to view this content.

[shg]

I was pondering why OT's code didn't work; and then it occurred to me that Caps Lock and Num Lock never make it out of the keyboard driver -- Excel wouldn't know what to do with them.

[Leith Ross]

Hello OptionTrader,

Here is a more succinct version of the API send keys.

VBA Module Code

Please Login or Register  to view this content.

ThisWorkbook_Open Event Code

Please Login or Register  to view this content.

[OptionTrader]

Thanks guys.

shg - Funny thing is original SendKeys code works fine in Excel 2007, but not 2003 (I need it to work in 2003).

Leith - Can't get that code to work.

Roy - Code works fine for Caps lock. How can I incorporate Num lock into the code ?

[Leith Ross]

Hello OptionTrader,

When dealing with API calls and most other code, it helps to know what Operating System you have. You should update your profile to include which operating systems you use. Roy's checks your operating system, that why his working. So, I can assume you are not using Windows 2000 through Windows XP.

[royUK]

Just searched through the code on another computer & found this

Please Login or Register  to view this content.

[D_Rennie]

sorry wrong page

[OptionTrader]

Hello OptionTrader,

When dealing with API calls and most other code, it helps to know what Operating System you have. You should update your profile to include which operating systems you use. Roy's checks your operating system, that why his working. So, I can assume you are not using Windows 2000 through Windows XP.

Hi Leith

The SendKeys code works fine when using Windows7/Excel2007, but not when using XP/Excel 2003. I need the code in the later combination.

Martin

[OptionTrader]

Roy, is there any chance you could include the code to also switch on the CapsLock? I'd be most grateful.

Martin

[royUK]

Roy, is there any chance you could include the code to also switch on the CapsLock? I'd be most grateful.

Martin

That's in the first code that I posted and in the second

[HaroonSid]

THANX
very useful to me