Closing with "Save" and "no save"

[amattey]

Hello,

I have a macro to close a workbook from which I automatically get updated information but I dont like that it always ask me to save or not. Is there a command to click "yes" to save, or "no", to not save?

 

[Ruddles]

When you close the workbook, you can specify SaveChanges:=True or SaveChanges:=False.

Or you can do a .Save on the workbook before you close it (if you want to save it).

Or you can set its .Saved property to True before you close it to make Excel think it doesn't need saving (if you don't want to save it).

 

[amattey]

Thank you. This place is awesome!

 

[Ruddles]

I make most of it up. I've already told you more than I know!