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?