what is the code to close a file for a macro

  • Thread starter Thread starter Celia
  • Start date Start date
C

Celia

I need to close a file in a macro but I am not sure how to do it. I could
use the following but when I use this a pop up screen says do you want to
save the changes to the file. I don't want to save the changes. Is there
any code to use that will eliminate the pop up asking me to save the file.

ActiveWindow.Close
 
or staying along the lines of your original code:

ActiveWindow.Close (False)
 

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

closing file without saving 1
Message still appears with DisplayAlerts = False & SaveChanges:=Fa 1
"Do You Want to Save Changes" message window 3
macro to close file and not save changes 3
Excel Macro Problem 2
Large Amount of Info on Clipboard 2
Disable save/saveas dialog box upon closing 11
Close a particular Word file from Exce; 3

Back
Top