| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Systematically Close File, Without Saving Changes
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Systematically Close File, Without Saving Changes
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. "Tom Ogilvy" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If I close a file without saving changes, can I get the autosaved | Excel Discussion (Misc queries) | |||
| Close file without saving | Excel Programming | |||
| Programatically close a file without saving | Excel Programming | |||
| Close file without saving | Excel Programming | |||
| Close file without saving | Excel Programming | |||
Linear Mode
