View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 172
Default 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?