Close Excel Completely Using VBA

C

Celtic_Avenger

Damn.......It does ask me if I want to save the changes.

Can this be stopped by adding another code after the

Application.Quit

Hpoe you can help!

Celtic_Avenge
 
E

E Oveson

Hmm, it is working for me. Make sure you make a call to Save right before
this call. Also make sure you save any other workbooks that might be open.
Also make sure if you haven't saved it before, to use SaveAs instead.

This worked for me:

activeworkbook.save ' or use saveas if you haven't saved it before
application.quit
 
Top