Systematically Close File, Without Saving Changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MWS - 20 Mar 2006 15:49 GMT

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

Reply to this Message

Tom Ogilvy - 20 Mar 2006 15:51 GMT

ActiveWorkbook.Close SaveChanges:=False

Signature

Regards,
Tom Ogilvy

> 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

Reply to this Message

David C - 20 Mar 2006 16:57 GMT

I found this works for me - I wanted to close Excel without saving any (all
files were read-only anyway), but that annoying message kept popping up.

First, in the 'QUIT' subroutine, I put ActiveWorkbook.Close
SaveChanges:=False [that stopped the messages] and then in the 'Before Close'
event I put Application.Quit

Works a treat, and faster too.

> ActiveWorkbook.Close SaveChanges:=False
>
[quoted text clipped - 3 lines]
> >
> > Thanks in advance

Reply to this Message