MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Slow down the SendKeys command

Posted by Joe Cognard on June 14, 2001 11:40 AM

Ive written a program to communicate with annother application, Each step of communication works fine, if I run each line 1 at a time.
However in the same program it sends stuff to fast.
How do I slow it down is there a way to tell excel to wait till other application is ready?

Posted by Might work on June 14, 2001 2:13 PM

Might work - might not : Try putting this in front of the send key commands tells Excel to wait for a sec (or you can to any timevalue)

Application.Wait Now() + TimeValue("00:00:01") ' Wait a sec

Posted by Joe Cognard on June 15, 2001 4:11 AM

I will try that.