View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Wait time before next command

Thanks, I got it working... I am 90% sure it was an application error that
was causing my first command not to work.

"Tom Ogilvy" wrote:

throw in a doevents before calling Wait each time.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
If I use this command and then again later in the code it freezes excel

for
20 seconds and then sends all the info to my other application. Shouldn't
this command send the code, then wait 10 secs, send more code, then wait

10
secs again...

Code
Application.Wait Now + TimeSerial(0, 0, 10)
More Code
Application.Wait Now + TimeSerial(0, 0, 10)

This seems to be trying to pause the application, not excel from sending

the
commands.

do i need to use something else?

"Tom Ogilvy" wrote:

Look at the wait command

--
Regards,
Tom Ogilvy

"John" wrote in message
...
I am trying to run a macro that sends information to a non-microsoft
application. I want to run several lines of code, then pause for a

couple
of
seconds to allow the application to process, then continue again with

the
code. How can I keep excel from sending information for a couple of
seconds
to let processing of my request happen, and then send new information.

Thanks for the help!