Closing files without save
Wrap you close code in
Application.DisplayAlerts = False
Workbooks(1).Close
Application.DisplayAlerts = True
In article <H3nUb.226302$xy6.1158245@attbi_s02,
"Warren" wrote:
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?
|