Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sendkeys(keys,wait) how do I use wait | Excel Discussion (Misc queries) | |||
Parameter Query to return multiple values | Excel Discussion (Misc queries) | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Web Query Sleep for until results come | Excel Worksheet Functions | |||
Sleep, Wait and Busy cursor functionality | Excel Programming |