Hi all,
I got a problem when navigate IE via vba. Below is my code, problem exists in the red words. After I input ticker and click "search" button, the IE jumps to another page, but when I wanna further click a link on the new page, the vba still "remembers" the old URL. How can I amend the code to let me have a chance to select links on the new page? Thank you so much.
Please Login or Register to view this content.
Hi,
That's because after you fired button.Click, the IE engine is still fetching the new page, but you already forced to pull information, so you got the old page.
You must wait IE engine until it is not busy and complete fetching the new page. So here the code :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Thank you Karedog, but the code is sometimes success ( I ran the code 10 times, but just 2 times I can load the page after the search button).
Originally Posted by karedog
Hi,
That's because after you fired button.Click, the IE engine is still fetching the new page, but you already forced to pull information, so you got the old page.
You must wait IE engine until it is not busy and complete fetching the new page. So here the code :
Please Login or Register to view this content.
That's strange, get 100% success rate here (I am using IE8 on my computer).
You can try to tell Excel gives more time by using Application.Wait() function.
In this sample, I tell Excel to give more two seconds at this line: Application.Wait (Now + TimeValue("0:00:02"))
You can try to change the value until you got 100% success rate.
Please Login or Register to view this content.
Last edited by karedog; 10-05-2014 at 04:47 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks