Click OK on a dialogue popup box

[bconner]

I am using Excel to scrap a website for information and return the results. Periodically the website will popup a dialogue box stating some question and then require an OK or Cancel response. So I don't have to babysitt the screen scrap is there code that can be written that will just select OK if a dialogue box pops up?

[Bob Phillips]

Sendkeys is the usual accepted way, although it does have its problems.

[bconner]

What is the code for recognizing if a msg box has popped up?