API call to replace SendKeys{TAB} function

[Derek]

Hello Forum Gurus

I desperately need ur help in this. In my company earlier we were using Windows XP and the VbA code that I had written in excel used to work perfectly fine with SendKeys{TAB} statements. But now we are moved to Windows 7 and this doesn't work anymore and sometime NUMLOCK automatically turns off too.

Can we use API Call to solve this problem?

Hope any of you can help me out.

Thanks
Derek

 

[gemma-the-husky]

out of interest, the only sendkeys I use is sendkeys "{esc}" - and that still seems to work.

this is a current article on the subject. hope it helps

http://www.contextures.com/excelvbasendkeys.html