Macro to Save without the Save Message

[Guest]

I am writing a macro that will ultimately close the workbook. However, I want
to save changes but I do not want the user prompted with the Do You Want To
Save Changes message. I simply want the workbook to save and close. I know
about DisplayAlerts -- but it appears that setting this to false stops the
Save message but does not keep the changes. Can anybody help?

Thanks so much.
Ellen

 

[Guest]

Try
application.save
application.quit (or application.close, depending upon whether you want to
close excel completely or not).

hope this helps,
-Chad

 

[Guest]

Save the workbook first by calling the Save or SaveAs method. Then you can
immediately close it and you won't get the prompt.

 

[Guest]

Hi Ellen

ActiveWorkbook.Close SaveChanges:=TRUE

 

[Guest]

I feel so stupid. I actually figured this out just before I saw everyone's
input. THANKS EVERYBODY!