CLOSING IN VBA

[davidgottlieb]

I am using this code:

ActiveWindow.Close

Is there a way that when VBA closes the form, that it not come up and ask "WOuld you like to save changes to file?"

[Gen-X]

If it is in word then you have to save the document first.

ActiveDocument.Save 0

The zero means don't ask for changes

[Joacim Andersson]

ActiveWindow.Close wdDoNotSaveChanges

[davidgottlieb]

That code does not work.

[davidgottlieb]

This is and Excel Workbook just a reminder. What is the code for that.

[Joacim Andersson]

ActiveWindow.Close False 'dont save changes
ActiveWindow.Close True 'saves the changes

[davidgottlieb]

You are a gift from God. Thank you so much

[da_silvy]

you can also use:

ActiveWindow.Close SaveChanged:=False