Does anybody know if it is possible to close Excel without being asked to save the changes to the spreadsheet?
I have an application that pushes data into various cells in Excel, allows it to make various calculations, reads results from other cells and then closes Excel using the commands:
OBJECT CALL oExcelApp.ActiveWindow.Close
OBJECT CALL oExcelApp.Quit
However this results in a message box "Do you want to save the changes to xxxxx.xls?". I never want to save the spreadsheet. Excel is hidden as it is opened so there are no clues to the user that Excel is performing the calculations apart from this message box.
Appreciate any help you can give me.
Thanks
Nick
I have an application that pushes data into various cells in Excel, allows it to make various calculations, reads results from other cells and then closes Excel using the commands:
OBJECT CALL oExcelApp.ActiveWindow.Close
OBJECT CALL oExcelApp.Quit
However this results in a message box "Do you want to save the changes to xxxxx.xls?". I never want to save the spreadsheet. Excel is hidden as it is opened so there are no clues to the user that Excel is performing the calculations apart from this message box.
Appreciate any help you can give me.
Thanks
Nick
Comment