Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing file without saving
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing file without saving
I'm having the same problem with a strange twist. I'm closing another
workbook, then the current workbook with the following code in Private Sub workbook_close(): Workbooks("real1.xls").Close False Me.Close False When I step through the code or run the code from the debug toolbar it works. But when I use File Exit or the X, it asks whether or not I want to save both files. I don't want to save either. What am I doing wrong? "Jacob Skaria" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
closing file without saving | Excel Programming | |||
closing file without saving | Excel Programming | |||
closing file without saving | Excel Programming | |||
skipping pop up box for saving changes when closing a file | Excel Programming | |||
closing a file without saving | Excel Programming |