Thread: Close file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David Coleman David Coleman is offline
external usenet poster
 
Posts: 28
Default Close file

You can either set

application.displayalerts to false

or there is the specific setting of

ActiveWorkbook.saved = true which, if set without having actually saved
the file, causes Excel to quit without prompting...

Hope these help

David


"mb" wrote in message
...
How do I close a file without saving the changes? I am using
ActiveWorkbook.close - is there a parameter I can add onto the end of this
statement?

MB