Close Excel Completely Using VBA

  • Thread starter Thread starter Celtic_Avenger
  • Start date Start date
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
 
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
 
Back
Top