| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Syntax to close Excel workbook not saving changes
In Excel 2000, I want to automate closing a file without saving changes.
This code does not give any error messages, but closes and does in fact save the changes: Sub DoNotSaveChanges() ' ' DoNotSaveChanges Macro ' Macro recorded 5/07/2008 by Grahame McEnery ' ' ActiveWorkbook.Close (SaveChanges = False) End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB Syntax to close Excel workbook not saving changes
activeworkbook.Close SaveChanges:=False
Cliff Edwards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| close workbook without saving or promt to save | Excel Discussion (Misc queries) | |||
| Close workbook without saving file | Excel Programming | |||
| Saving VBA project on workbook close | Excel Programming | |||
| close excel without saving | Excel Programming | |||
| Close a workbook without saving macros | Excel Programming | |||
Linear Mode
