Z
Zef
I have been using Office 2003 for some time. I created a macro which involved
the Sendkeys function and required it to wait until the keystrokes were
entered. It worked fine. After I upgraded to Vista and Office 2007 (new
computer), I re-created the same macro. This time, Sendkeys refuses to wait
until the keystrokes are entered, even though I set the wait value to True. I
tried stopping the macro after Sendkeys function, and it worked fine. But I
needed it to move focus to another form after it was done. If I add that
function, it entered the keystrokes in the new form, instead of entering it
into the table it was supposed to before moving focus to the new form. How do
I ensure it should wait for the keystrokes to be entered?
the Sendkeys function and required it to wait until the keystrokes were
entered. It worked fine. After I upgraded to Vista and Office 2007 (new
computer), I re-created the same macro. This time, Sendkeys refuses to wait
until the keystrokes are entered, even though I set the wait value to True. I
tried stopping the macro after Sendkeys function, and it worked fine. But I
needed it to move focus to another form after it was done. If I add that
function, it entered the keystrokes in the new form, instead of entering it
into the table it was supposed to before moving focus to the new form. How do
I ensure it should wait for the keystrokes to be entered?