LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Web Access Timeout


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate (F9) - Timeout BR Excel Discussion (Misc queries) 1 March 11th 09 06:19 PM
MsgBox with timeout pgarcia Excel Discussion (Misc queries) 1 March 8th 07 10:06 PM
TImeIn-TimeOut-TimeIn-TimeOut-HoursWorked ChefBoiRD Excel Worksheet Functions 3 September 20th 05 10:01 AM
Timein-Timeout Jim Stewart Excel Programming 2 September 1st 03 09:49 AM
Web query timeout Karyn Mak Excel Programming 0 July 16th 03 11:48 AM


All times are GMT +1. The time now is 02:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"