Hi,

I am using SENDKEYS to help to enter data into Peachtree (an
accounting program). I have set the sequence of the data entry exactly
the same as if the data was entered by me using the keyboard. So the
result in Peachtree is the same.

The different is that when EXCEL using sendkeys to send the keystroke,
the NUMLOCK status will on and off and on and off. So after the
current data are all passed to Peachtree and go back to EXCEL, I have
to look at the number lock status and turn it on if it is off, before
I can use the kkeypad to enter another data. No all the time will off.
So I have to check it every time after the VBA has run.

I have tried this in other program (IE / NOTEPAD / ACDSee) and have
the same problem. Any suggestions on anything I have done wrong?

Thanks.

---
Please remove NOSPAM- in the email address when replying by email.

Take a look here,
http://support.microsoft.com/default...b;en-us;179987

If that doesn't help then you might want to completely do away
with Sendkeys and use pure APIs to do the job. In most cases you
can use functions like EnumWindows & EnumChildWindows to drill down
to a particular textbox within an app and then use SendMessage to
write text to it. It's a lot trickier than Sendkeys but a lot more
robust too.
I'm sure the folks over at microsoft.public.vb.winapi would be glad to help.


Regards,
Vic Eldridge


Kenneth Lam wrote in message . ..
Hi,

I am using SENDKEYS to help to enter data into Peachtree (an
accounting program). I have set the sequence of the data entry exactly
the same as if the data was entered by me using the keyboard. So the
result in Peachtree is the same.

The different is that when EXCEL using sendkeys to send the keystroke,
the NUMLOCK status will on and off and on and off. So after the
current data are all passed to Peachtree and go back to EXCEL, I have
to look at the number lock status and turn it on if it is off, before
I can use the kkeypad to enter another data. No all the time will off.
So I have to check it every time after the VBA has run.

I have tried this in other program (IE / NOTEPAD / ACDSee) and have
the same problem. Any suggestions on anything I have done wrong?

Thanks.

---
Please remove NOSPAM- in the email address when replying by email.

Here's a post by Tom Ogilvy of a Jim Rech post:

http://groups.google.com/groups?&thr...%40tkmsftngp02

Maybe you can dump the SendKeys totally.

Kenneth Lam wrote:

Hi,

I am using SENDKEYS to help to enter data into Peachtree (an
accounting program). I have set the sequence of the data entry exactly
the same as if the data was entered by me using the keyboard. So the
result in Peachtree is the same.

The different is that when EXCEL using sendkeys to send the keystroke,
the NUMLOCK status will on and off and on and off. So after the
current data are all passed to Peachtree and go back to EXCEL, I have
to look at the number lock status and turn it on if it is off, before
I can use the kkeypad to enter another data. No all the time will off.
So I have to check it every time after the VBA has run.

I have tried this in other program (IE / NOTEPAD / ACDSee) and have
the same problem. Any suggestions on anything I have done wrong?

Thanks.

---
Please remove NOSPAM- in the email address when replying by email.

--

Dave Peterson

It worked ok for me in xl2002 and win98.



Kenneth Lam wrote:

On Wed, 02 Jun 2004 21:29:26 -0500, Dave Peterson
wrote:

Thanks very much.

I have just tried this but it doesn't work in my Excel 2000. Maybe it
is for Excel 5 only.

Best Regards.

Here's a post by Tom Ogilvy of a Jim Rech post:

http://groups.google.com/groups?&thr...%40tkmsftngp02

Maybe you can dump the SendKeys totally.

Kenneth Lam wrote:

Hi,

I am using SENDKEYS to help to enter data into Peachtree (an
accounting program). I have set the sequence of the data entry exactly
the same as if the data was entered by me using the keyboard. So the
result in Peachtree is the same.

The different is that when EXCEL using sendkeys to send the keystroke,
the NUMLOCK status will on and off and on and off. So after the
current data are all passed to Peachtree and go back to EXCEL, I have
to look at the number lock status and turn it on if it is off, before
I can use the kkeypad to enter another data. No all the time will off.
So I have to check it every time after the VBA has run.

I have tried this in other program (IE / NOTEPAD / ACDSee) and have
the same problem. Any suggestions on anything I have done wrong?

Thanks.

---
Please remove NOSPAM- in the email address when replying by email.

---
Please remove NOSPAM- in the email address when replying by email.

--

Dave Peterson