I am trying to do a SendMessage against a msgbox. If the msgbox has two choices such as Yes and No. How do I make it click No?

The msgbox I am trying to click is from Excel.

If you can generate the msgbox with a vbYesNo in Excel and from VB trying to click the No.

I am able to sendmessage on the Yes, but don't know how to do it to the No.

I was using FindWindow and FindWindowEx to do this with SendMessage.

Another thing, what is the difference with SendMessage, SendMessagebyString, SendMessagebyNum, SendMessageCallback, SendNotifyMessage, SendMessageTimeout?

Thanks

[Edited by Shark on 07-29-2000 at 10:28 PM]