VB Syntax to close Excel workbook not saving changes

G

Greyman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to perform on closing an Excel Workbook 4
Macro to close without saving 5
Syntax to close Workbook 5
Fix code - check to see if a workbook is open, if so, save changes then close. 6
Save as PDF not working on a domained Windows 7/Vista box 2
Lose macros before saving 4
Macro "not to check compatibility when saving this workbook" 4
Macro not to check compatibility when saving this workbook 2

Top