| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to Exit Excel
I currently use a close workbook code, but
have decided to rather have a exit Excel code. Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to Exit Excel
Corey,
Application.Quit will complete terminate Excel. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Corey" wrote in message ... I currently use a close workbook code, but have decided to rather have a exit Excel code. Is this possible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to Exit Excel
Thnaks
How can i place a SAVE step before that then Exit? Corey.... "Chip Pearson" wrote in message ... Corey, Application.Quit will complete terminate Excel. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Corey" wrote in message ... I currently use a close workbook code, but have decided to rather have a exit Excel code. Is this possible? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to Exit Excel
Try
Dim WB As Workbook For Each WB In Workbooks WB.Close savechanges:=True Next WB Application.Quit -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Corey" wrote in message ... Thnaks How can i place a SAVE step before that then Exit? Corey.... "Chip Pearson" wrote in message ... Corey, Application.Quit will complete terminate Excel. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Corey" wrote in message ... I currently use a close workbook code, but have decided to rather have a exit Excel code. Is this possible? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to Exit Excel
I now get a save, but a close instead of an exit??
"Chip Pearson" wrote in message ... Try Dim WB As Workbook For Each WB In Workbooks WB.Close savechanges:=True Next WB Application.Quit -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Corey" wrote in message ... Thnaks How can i place a SAVE step before that then Exit? Corey.... "Chip Pearson" wrote in message ... Corey, Application.Quit will complete terminate Excel. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Corey" wrote in message ... I currently use a close workbook code, but have decided to rather have a exit Excel code. Is this possible? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code to Exit Excel
If a workbook has never been saved to disk, you'll get the Save
As dialog. If you don't want to save the workbooks before closing Excel, change savechanges:=True to savechanges:=False -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Corey" wrote in message ... I now get a save, but a close instead of an exit?? "Chip Pearson" wrote in message ... Try Dim WB As Workbook For Each WB In Workbooks WB.Close savechanges:=True Next WB Application.Quit -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Corey" wrote in message ... Thnaks How can i place a SAVE step before that then Exit? Corey.... "Chip Pearson" wrote in message ... Corey, Application.Quit will complete terminate Excel. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Corey" wrote in message ... I currently use a close workbook code, but have decided to rather have a exit Excel code. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exit Code Upon Cancel On Type 8 Input Box | Excel Discussion (Misc queries) | |||
| Excel 07 won't exit | Setting up and Configuration of Excel | |||
| Execute vba code on cell exit | Excel Discussion (Misc queries) | |||
| exit excel within vba | Excel Programming | |||
| If a called sub exit, how to the caller exit right away? | Excel Programming | |||
Hybrid Mode
