View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Systematically Close File, Without Saving Changes

ActiveWorkbook.Close SaveChanges:=False

--
Regards,
Tom Ogilvy


"MWS" wrote:

Hello, I have an excel program and want to give the user a method to simply
stop using the file, and close it without "saving" any of the data. Can
anyone tell me what code to use?

Thanks in advance