Coded response to 'save changes' response

[jwebb]

I am using a vb.net application to manipulate an excel application. Is there any way to use vb code to respond 'No' to the usual prompt that appears when you try to close an excel app without having saved new information?

"Do you want to save the changes you made to ..."

 

[aBsOlUt]

Use this in your workbook class:

excelWorkbook.Saved = True