Web Query Sleep or Wait for return values
 

Hello all excel users-

I have excel run a CGI through a web query, which runs a script on
UNIX box. The script runs for 3 minutes and the spits out a file.
was wondering how to make excel wait the 3 minutes, and not crap ou
with an error "Unable to get information from ..."? Is it possible t
make excel wait or sleep that long while it waits?

Thanks

-suni

--
Sunil_Mod
-----------------------------------------------------------------------
Sunil_Modi's Profile: http://www.excelforum.com/member.php...fo&userid=1653
View this thread: http://www.excelforum.com/showthread.php?threadid=31880

Web Query Sleep or Wait for return values
 

Assuming code has been executed in excel, one of the
following should help.

Wait Method Examples

This example pauses a running macro until 6:23 P.M. today.

Application.Wait "18:23:00"
This example pauses a running macro for approximately 10
seconds.

newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 10
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime
This example displays a message indicating whether 10
seconds have passed.

If Application.Wait(Now + TimeValue("0:00:10")) Then
MsgBox "Time expired"
End If

-----Original Message-----

Hello all excel users-

I have excel run a CGI through a web query, which runs a
script on a
UNIX box. The script runs for 3 minutes and the spits
out a file. I
was wondering how to make excel wait the 3 minutes, and
not crap out
with an error "Unable to get information from ..."? Is
it possible to
make excel wait or sleep that long while it waits?

Thanks

-sunil


--
Sunil_Modi
----------------------------------------------------------
--------------
Sunil_Modi's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=16533
View this thread:
http://www.excelforum.com/showthread...hreadid=318802

.

Web Query Sleep or Wait for return values
 

set it as a backgroundquery ?
and have a ontime proc check if the file is there?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Sunil_Modi wrote :


Hello all excel users-

I have excel run a CGI through a web query, which runs a script on a
UNIX box. The script runs for 3 minutes and the spits out a file. I
was wondering how to make excel wait the 3 minutes, and not crap out
with an error "Unable to get information from ..."? Is it possible to
make excel wait or sleep that long while it waits?

Thanks

-sunil