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.