Exit from Excel window
 

How do I close the whole Excel window? My goal is to exit without saving
data. If I write:
this.Close(false, missing, missing); (in ThisWorkbook_BeforeSave event)
the workbook closes without save, but the Excel window stays open, and thus
the project is still in running mode.
Thanks :)

Exit from Excel window
 

Sandrina, use this,

Application.Quit

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sandrina" wrote in message
...
How do I close the whole Excel window? My goal is to exit without saving
data. If I write:
this.Close(false, missing, missing); (in ThisWorkbook_BeforeSave event)
the workbook closes without save, but the Excel window stays open, and
thus
the project is still in running mode.
Thanks :)

Exit from Excel window
 

Sandrina:
try,

ThisWorkbook.Saved = True
Application.Quit

--
天行å�¥ï¼Œå�›å*�以自強ä¸�æ�¯
地勢å�¤ï¼Œå�›å*�以厚德載物

http://www.vba.com.tw/plog/


"Sandrina" wrote:

How do I close the whole Excel window? My goal is to exit without saving
data. If I write:
this.Close(false, missing, missing); (in ThisWorkbook_BeforeSave event)
the workbook closes without save, but the Excel window stays open, and thus
the project is still in running mode.
Thanks :)

Exit from Excel window
 

Thanks, but this doesn't work if you are in the BeforeSave event - it still
displays the SaveAs dialog. I solved the problem like this:

Application.DisplayAlerts = false;
Cancel = true; // the cancel that is provided as the BeforeSave argument
Application.Quit();
return;

"chijanzen" wrote:

Sandrina:
try,

ThisWorkbook.Saved = True
Application.Quit

--
天行å�¥ï¼Œå�›å*�以自強ä¸�æ�¯
地勢å�¤ï¼Œå�›å*�以厚德載物

http://www.vba.com.tw/plog/


"Sandrina" wrote:

How do I close the whole Excel window? My goal is to exit without saving
data. If I write:
this.Close(false, missing, missing); (in ThisWorkbook_BeforeSave event)
the workbook closes without save, but the Excel window stays open, and thus
the project is still in running mode.
Thanks :)