Closing excel without the "Save Changes" dialog

[studybum]

I have a program that utilizes an excel formula. I created a mobjExcel as an new application. On the form unload I have mobjExcel.quit. The program comes back with a question, "Do you want to save changes to the current Workbook?" How do I keep this from opening?

When I shut down the computer another dialog came up asking if I wanted to close excel. What am I missing?

 

[dsi]

'Close the Workbook
objWB.Close saveChanges:=False

'Or, just close the Application
objExcel.DisplayAlerts = False
objExcel.Quit

Hope this helps!