Closing files without save
Application.cutcopymode=false
Activeworkbook.close savechanges:=false
-----Original Message-----
I am writing a macro which opens and closes a series of
other workbooks.
When I close a workbook, Excel prompts me if I want to
save the file and if
I want to delete whatever is left on the clipboard.
How can I, in VBA, close a workbook without saving it and
not have Excel
displaying a dialog box asking if I want to save?
Also, how can I surpress the question about the
clipboard, and automatically
have Excel to discard those items left on the clipboard?
Thanks in advance,
Warren
|