Closing Excel without saving data

[Marc Vanzegbroeck]

Hi,

In an application i'm writing, I open an excel-file, select and copy data to the clipboard, and want to close the excel again.
It's working nice, but the problem is that excel ask:
- Do want to save the changes?
- Do you want to leave the data in the clipboard?

Is it possible to close it without those messages?

Thanks

[Antonio Linares]

This may help:

http://www.exceltip.com/files-workbook-and-worksheets-in-vba/delete-sheets-without-confirmation-prompts-using-vba-in-microsoft-excel.html

[Antonio Linares]

https://msdn.microsoft.com/en-us/library/bb177478(v=office.12).aspx

[Marc Vanzegbroeck]

Thank you Antonio.

It's working now with

Code: Select all  Expand view

oExcel:Displayalerts(.f.)