Wait time before next command
 

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!

Wait time before next command
 

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!

Wait time before next command
 

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!

Wait time before next command
 

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!

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!