Trap Cancel Button Without Using MessageBox Class

Question

I have a file that opens automatically with an excelApp.Workbooks.Open statement, i.e., I'm not using MessageBox.Show. If the file is in use, I get the message, "'filenam' is being modified. Open as read-only", with OK and Cancel as options. I need to trap the "Cancel" option so I can take various actions if the user chooses this. But since I didn't use the MessageBox, class, how do I do this?

Tim Bostwick · Answer

John: I'll give that a try and report back. Thanks.

Sunny Chen · Answer

I don't know if I understand your question correctly.
In your customized "MessageBox" dialog, put the "Cancel" button and set its "DialogResult" property to "Cancel". And in your caller form, coding as following (Suppose your "MessageBox" is MyDialog): MyDialog dlg = new MyDialog();
if (dlg.ShowModal() == DialogResult.Cancel)
{
// User has clicked the "Cancel" button.
}
Hope this helps.

Guest User · Answer

I haven't tried this myself, but try checking the value of Workbooks.Count before and after you call Workbooks.Open.  If it remains unchanged, that should indicate that the workbook wasn't opened.
HTH