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.

John Penn · 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