Sub LOADIE() Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.navigate "www.excelpx.com" '←打开某个网页,要一定时间,但代码会往下执行' Do Until IE.Readystate = 4 ' 检查网页是否加载完毕(4表示完全加载) Do Until IE.busy DoEvents ' 循环中交回工作权限给系统,以免“软死机” LoopEnd Sub
谢谢!
Property ReadyState As tagREADYSTATE,有5种情况
Const READYSTATE_COMPLETE = 4Const READYSTATE_INTERACTIVE = 3Const READYSTATE_LOADED = 2Const READYSTATE_LOADING = 1Const READYSTATE_UNINITIALIZED = 0
使用道具 举报
谢谢吕布!
学习,为什么不好找列?
试验了一下,两者应该是不同的Sub LOADIE()' 默认浏览器设为IE Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.navigate "www.excelpx.com" '←打开某个网页,要一定时间,但代码会往下执行 IE.Visible = False Debug.Print IE.Busy, CLng(IE.ReadyState) Do Until IE.ReadyState = 4 ' 检查网页是否加载完毕(4表示完全加载) ' Do Until IE.busy Debug.Print IE.Busy, CLng(IE.ReadyState) DoEvents ' 循环中交回工作权限给系统,以免“软死机” Loop Debug.Print IE.Busy, CLng(IE.ReadyState)End Sub
结果是
False 3 False 3 False 4
结果是Busy一直是False,而ReadyState 则一直变化
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-18 13:31 , Processed in 0.315778 second(s), 9 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.