Stop Excel Saving Via VBA

[kingy]

Im currently programming a excel workbook but when the code application.quit is used a confirmation box appears saying do you want to save blah blah, yes, no, cancel etc.

Is there a way of getting excel to close but not displaying this message box, i could use activeworkbook.save then application.quit but the problem is in this instance i dont want to save the workbook, any ideas ne one???

 

[seacrest]

Try this
Sub TEST()
ActiveWorkbook.Close SaveChanges:=False
End Sub

 

[seacrest]

Try this
Sub auto_close()
ActiveWorkbook.Close SaveChanges:=False
End Sub

 

[kingy]

Thanks, that works a treat!