View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Warren Warren is offline
external usenet poster
 
Posts: 5
Default Closing files without save

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