I have a VBA Program that logs into a web site, selects one web page, scrapes certain data from that web page then goes onto the next web page and repeats the process. There can be a few thousand web pages at the web site that I collect data from. The program is up and operating and collects the desired data.

My problem is that during the operation of the VBA program, the web site occasionally sends a "Message from Web Page." the message stops my VBA program until an OK button is clicked manually. The program can run a few hours to collect all the data and it is impractical to manually click the OK button every time it appears.

I am looking for a way prevent the message from stopping the VBA code or blocking the message from coming up.

I have tried Application.DisplayAlerts = False; Sendkeys; and Excel's pop up blocker without success.

Since once the Message is displayed I cannot click the button with VBA since the VBA program has stopped.

Any help will be greatly appreciated.