If I run this in the editor sometimes it works and sometimes it does not.
If I run this in editor with F8, stepping through the code, it does work. I can only guess that enough time is passing during the F8 presses that the page can load.
But is that not the purpose of adding the wait code?
Please Login or Register to view this content.
Hi hgtenn,
When I have these timing problems I add some "DoEvents" commands to my code. They tell the OS to go do other things (like wait for the whole file to open) before trying to execute more code. Give a few of them a try when you think the code should be waiting instead of Wait commands.
http://support.microsoft.com/kb/118468
http://msdn.microsoft.com/en-us/libr.../gg264522.aspx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
MarvinP, thanks for the reply.
A bit more guidance please. I have "DoEvents" in the code already.? Are you suggesting to add more, or move around the existing DoEvents?
Can you show where in one example?
Also there is java in the pages. I just saw something elsewhere that mentions there may be additional items happening after the page loads...if that makes any sense.
I'd take the DoEvents out of the loops.
I'd add one (or two) after you go to your website.
Id add one after you switch sheets or do something that is "outside" of Excel.
I was hoping to not have to read your code but simply have you try...
Sorry :-) I have tried two different methods for waits.
I tried...seems to make no difference, gets to the end of the code very quickly.
Took them out of the loops and placed them between each block.
Please Login or Register to view this content.
Hello, can anyone help with this please?
(I put this together following a tutorial on youtube(web scraper vba), I am not that skilled in vba, but trying!)
I added the DoEvents (post #5). It seems to make no difference. If I step through the code it's getting enough time to complete and work as expected.
If I simply run the code in the editor, even after littering it with DoEvents, the code still flies through to the end.
Is there a better method to adding a wait? Is there is way to make sure the waits are triggered?
Have you tried adding a loop to wait for the document to be fully loaded?
If posting code please use code tags, see here.
If you look at the code, then you see the below.
Isn't that the loop to wait for the page to load?
Please Login or Register to view this content.
Hello,
Still looking for resolve on this issue. There are ReadyState loops in the code. So I do not know what else to add or where to add it.
That code isn't waiting for the document to load, it's waiting for IE to reach a complete ready state.
The code to wait for the document to load would look something like this.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks