View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default closing file without saving

ActiveWindow.Close False

--
If this post helps click Yes
---------------
Jacob Skaria


"Novice Lee" wrote:

How can I close a file without saving the file automatically.
I use the following code for closing the file:
Windows("MasterData - 2009.XLS").Activate
ActiveWindow.Close

is any thing I can add to it or change so I don't get the "Do you want to
say" box? I never want to save the file.

Thanks