Quitting Excel from code

Hi,
I open Excel in non-visible mode from VB. If an error occurs I make sure Excel is closed in the correct manner, however, if data has been added to a sheet and the close instruction is run a message box appears asking if I wish to save the spreadsheet.

Anyone know how I can prevent this message from appearing without destroying Excel in a horrible way? I guess I'm after some method of pressing the 'no - don't save' button on the Excel messagebox.

xlApp.DisplayAlerts = False

If you have an excel object in vb you can do this


xlApp.DisplayAlerts = False

Then it won't give you any messages from excel and it will treat it as you don't want to save.

:D