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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Close Excel Completely Using VBA 0
Office 365 Outlook adding unwanted HTML to Email Body 0
Print A For (docm), Send Email Attachment And Close For Without Saving 2
Close Excel Completely Using VBA 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Word 2003 won't exit 8
Getting Radio Buttons to work, that are inserted via AutoText 0
Need help modifying code 0

Top