how to click javascript alert button when using IE

Hi all,

I am using below code (method from this web) to extract data from the web, the problem I am facing is the popup alert message from the web which stop my procedure to further execute.

This is the web code of the search button (sorry that I dunno the reason of failure to post the full search button web code on the forum, so I just extract part of it)

HTML Code: 

Could anyone tell me how to solve the problem of frozen vba procedure after the popup of the alert? Many thanks!!

Please Login or Register  to view this content.

to add more background information,
1.) I cannot click any button on VBE after the red line, but I can still control/operate other window objects such as outlook and chrome.
2.) If I tried the website which is from the original example from this web https://social.technet.microsoft.com...tprocurrentver, everything works fine. So I dunno if my problem is due to the search button generated by Javascript .

Originally Posted by AB33

It freezes because you have inserted an invalid date as you can see the error on the site. Change the year in to "2016" and will take you to next page.

Thanks, AB33.
This is an intended attempt to insert a invalid date because users always got a chance to insert the date like this case.
When this happens, they need to manually click ok in the popup alert.
So, I am seeking help on this forum to see if experts can any idea to solve this issue.

Originally Posted by Kyle123

What information is it that you're trying to extract from the next page?

The data I would like to extract is a table, but what is the relationship between your question and my problem?

Originally Posted by Kyle123

Because this is an example of an xy problem, you don't need to use IE at all to get the information. The question should be, how do I get the info rather than how do I deal with the box in IE.

The reason I asked the question was that if you didn't need to extract the data and just needed to open the page then the method becomes more relevant

ok, I see. Because there is a captcha (session-token) which changes every time when I send the web request to the server by using xmlhttp request method, and I cannot solve the issue of changing captcha. So, I change to use IE automation to extract the data.

Please Login or Register  to view this content.

This is the captcha which changes every time I send the web request.
Until now, I am able to manage the data extraction. However, when there is a javascript popup alert (as described above), I could do nothing. That's why I am posting a thread on the forum. If anyone of you has idea to workaround the issue, pls let me know. Thanks again.

Originally Posted by Kyle123

Where do you see a captcha on that page? I don't

after entered

HTML Code: 

, view source code and search by "sessionToken", this is one of the inputs required in order to successfully load next page. The value of sessionToken changes every time when I open a new browser

Originally Posted by Kyle123

That's not a captcha - a captcha is designed to stop bots, that's just a session token. This worked for me:

Please Login or Register  to view this content.

Amazing!!Kyle123, you are deserved to add reputation, thanks again!!
BTW, just for curiosity, if back to my original problem (vba procedure was frozen after running the red line), do you have any idea?
Use the same method, some website could apply while others do not.

is it another field of vba? I wanna learn how to control other window objects (in this case the popup alert)?

Originally Posted by Kyle123

You need to look into window handling with sending messages, you use the Windows api. It's an incredibly unsatisfying and painful learning experience - it's very easy to crash excel when faffing with these things

Hi Kyle123, regarding your solution, there are 2 points that I don't quit understand, could you kindly explain a little bit more?
1.) what's the purpose of this portion of code
.Open "GET", url, False
.send
doc.body.innerhtml = .responsetext
Is this used to extract the sessiontoken?

2.) why there is no need to have .Setheaderrequest in http get part?

Thank you so much