Closing an Unsaved (but Changed) Workbook
Thanks Bill!
-----Original Message-----
Switch the order
Application.Quit
ActiveWorkbook.Close SaveChanges:=False
Quits, but does not bring up save changes dialog
-----Original Message-----
But once the workbook is closed, it won't reach the last
line and close Excel.
-----Original Message-----
ActiveWorkbook.Close SaveChanges:=False
-----Original Message-----
How do I close a worksheet that I've changed (at the
same
time that I close Excel), but don't want the changes to
be
permanent? I tried using the following code:
ActiveWorkbook.Saved = True
Application.Quit
However, it doesn't work; it still asks me whether I
want
to save the changes.
.
|