Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Just a safety tip ... Notwithstanding the documentation, ReadyState = READYSTATE_COMPLETE is NOT a reliable way to check for the web page actually being completely downloaded. While it will work much of the time, there are many sites that will generate ReadyState complete (particularly on a frame), and then proceed to continue to load (generally in other frames). A stronger technique is to catch the DocumentComplete event for the IE main window. This will work almost always but will fail for certain sites that do not complete their loading untill after the IE main window signals load complete. On Sat, 21 Feb 2004 13:10:03 -0600, "Dick Kusleika" wrote: Nigel Create a date variable and check NOW vs some start time Dim StartTime as Date StartTime = Now Do Until oIE.ReadyState = READYSTATE_COMPLETE Or (Now-StartTime)TimeValue("00:00:15") DoEvent Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate (F9) - Timeout | Excel Discussion (Misc queries) | |||
MsgBox with timeout | Excel Discussion (Misc queries) | |||
TImeIn-TimeOut-TimeIn-TimeOut-HoursWorked | Excel Worksheet Functions | |||
Timein-Timeout | Excel Programming | |||
Web query timeout | Excel Programming |