Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi, I am using sendkeys to enter data into Peachtree. I found that after Excel changed to Peachtree and start entering, the number lock "sometimes" will on and off for several times. I have tried to write a "plain" macro with "sendkeys" only and test on other software and found it is the same. The status will also change. The pattern is not fixed. That is under the same problem and same string being sent, sometimes will flash 2 times and sometimes may flash 5 times. Any suggestions? Thanks. --- Please remove NOSPAM- in the email address when replying by email. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Option Explicit
Declare Function SetKeyboardState Lib "User32" (kbArray As Byte) As Long Sub toggleit() Dim KeyState(0 To 255) As Byte KeyState(&H90) = 1 'for on 0 for off SetKeyboardState KeyState(0) End Sub Worked ok for me in win98. Kenneth Lam wrote: Hi, I am using sendkeys to enter data into Peachtree. I found that after Excel changed to Peachtree and start entering, the number lock "sometimes" will on and off for several times. I have tried to write a "plain" macro with "sendkeys" only and test on other software and found it is the same. The status will also change. The pattern is not fixed. That is under the same problem and same string being sent, sometimes will flash 2 times and sometimes may flash 5 times. Any suggestions? Thanks. --- Please remove NOSPAM- in the email address when replying by email. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
"lock" fields so they don't change number while copying formulas? | Excel Discussion (Misc queries) | |||
Formulae or format to change a number "1" into the word "one | Excel Discussion (Misc queries) |