[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

Excel VBA & Internet Explorer Automation: How to catch alert message events?

Asked by robofix in Visual Basic Programming, Automation, Microsoft Excel Spreadsheet Software

Hi,
I'm downloading data from an ssl-secured internet website to excel and face one problem:
Sometimes, no data is found, and the macro should just go on with the next request. An alert message is displayed, which interrupts the flow of the automation, since it has to be acknowledged (click "ok" or press "Enter") - how can I automate this too?

First thing would be to catch the event itself, so that my macro knows how to proceed further because the data was not found.
Second, the alert box should be clicked/stroken away automatically or not even appear.
I've browsed a few threads about similar issues here, but have not found a solution for me yet.

Best,
Rob
[+][-]11/06/09 09:33 PM, ID: 25765120Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/07/09 03:31 AM, ID: 25765872Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625