Closing Excel without saving data - FiveTech Support Forums

Board index FiveWin for Harbour/xHarbour Closing Excel without saving data

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Closing Excel without saving data
Posted: Wed Sep 30, 2015 10:18 AM

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

Regards,

Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite

Antonio Linares

Posts: 44162

Joined: Thu Oct 06, 2005 05:47 PM

Re: Closing Excel without saving data
Posted: Wed Sep 30, 2015 10:34 AM

This may help:

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

regards, saludos

Antonio Linares
www.fivetechsoft.com

Antonio Linares

Posts: 44162

Joined: Thu Oct 06, 2005 05:47 PM

Re: Closing Excel without saving data
Posted: Wed Sep 30, 2015 10:36 AM

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

regards, saludos

Antonio Linares
www.fivetechsoft.com

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: Closing Excel without saving data
Posted: Wed Sep 30, 2015 11:26 AM

Thank you Antonio.

It's working now with

Code (fw): Select all Collapse

oExcel:Displayalerts(.f.)

Regards,

Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite

Continue the discussion