Quit Excel without getting option to save 8

[OzzieOwl]

I need to be able to use the Application.Quit command to exit an excel document but I don't want the option to save if any changes have been made, does anyone know how to disable this option through VBA ?

Cheers

Martin

 

[xlbo]

Set the saved property to true

application.displayalerts = false
saved = true
application.quit

should do the trick Rgds
~Geoff~

 

[TopJack]

An alternative to above reply could be this ......

ActiveWorkbook.Close SaveChanges:=False
Application.Quit

Hope this helps.

 

[benjamenus]

another option

Workbooks(1).Close (Excel.XlSaveAction.xlDoNotSaveChanges)