API Calls to replace SendKeys{TAB} function

Hello All

I desperately need your help in this. In my company earlier we were using Windows XP(Excel 2007) 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(Excel 2010) 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

You'll need to give us a bit more than that.

What was this send keys doing? Do you have any experience using windows apis?

Also, please post your code

Thanks Kyle, I have been using SendKeys{TAB} command many time in one project. So Now I need to replace it with API . The below is one example where SendKeys{TAB} is used but there are lots of functions where I'm using SendKeys{TAB} command.There are so many controls in the form that I'm making visible and invisible one after another to record data about the batches.

Please Login or Register  to view this content.

What's the tab supposed to do? Can't you just use SetFocus. I see no need for APIs?

Tab is moving focus to controls. I can't use set focus because there are so many controls in one form and they are not visible all together. First one control becomes visible and ask user to input the data and then another one gets visible so my manager asked me to use APIs to replace SendKeys{TAB} commands.

NUMLOCK automatically turns off too

See http://www.ozgrid.com/forum/showthread.php?t=192625

Same code can be used to send a TAB with a little change...

Don't use either. You should be using SetFocus, as in

Please Login or Register  to view this content.

Originally Posted by aman1234

Tab is moving focus to controls. I can't use set focus because there are so many controls in one form and they are not visible all together. First one control becomes visible and ask user to input the data and then another one gets visible so my manager asked me to use APIs to replace SendKeys{TAB} commands.

So make it visible, then setfocus.

Kyle, Its very difficult to explain you why I don't want to use setfocus. There are way to many controls and lots of conditions in the back . I have used SendKeys{TAB} too many times in the code so just want to replace it using API call function . I don't want to make the controls visible or invisible and use setfocus as suggested as suggested by my boss.
I really like the link that grimes0332 shared in this thread. Can anyone please help me how to use TAB in that code. So replacing SendKeys{TAB} with APIs.

Kyle, sorry can't upload my excel workbook due to security restrictions in my company but setfocus wont work here. Would really appreciate if you can suggest some other way to this.

Many Thanks

Added tab:

Please Login or Register  to view this content.

Thanks Kyle, Is it the API function?

Kyle Many Thanks for your help so far. Can you pls tell me What is the difference between using SendKeys{TAB} and using this to press TAB?

Originally Posted by aman1234

I really like the link that grimes0332 shared in this thread. Can anyone please help me how to use TAB in that code. So replacing SendKeys{TAB} with APIs.

You said that's what you wanted?

What's the difference? Nowt I reckon - they're equally bad

Just wanted to double check is it the API call ?

It's an API call, there's no such thing as the API call. An API call in this context is just calling one of many functions built into the windows operating system

This is exactly what I was looking for. Thanks so much Kyle.