Share via

DocumentBeforeSave Event

  • Article

Occurs before any open document is saved.

Private Subobject**_DocumentBeforeSave(ByVal** Doc As Document, SaveAsUI As Boolean, Cancel As Boolean)

object An object of type Application declared with events in a class module. For more information about using events with the Application object, see Using Events with the Application Object .

Doc The document that's being saved.

SaveAsUITrue to display the Save As dialog box.

CancelFalse when the event occurs. If the event procedure sets this argument to True, the document isn't saved when the procedure is finished.

Example

This example prompts the user for a yes or no response before saving any document. This code must be placed in a class module, and an instance of the class must be correctly initialized in order to see this example work; see Using Events with the Application Object for directions on how to accomplish this.

Public WithEvents appWord as Word.Application

Private Sub appWord_DocumentBeforeSave _
        (ByVal Doc As Document, _
        SaveAsUI As Boolean, _
        Cancel As Boolean)

    Dim intResponse As Integer

    intResponse = MsgBox("Do you really want to " _
        & "save the document?", _
        vbYesNo)

    If intResponse = vbNo Then Cancel = True
End Sub

Applies to | Application Object

See Also | DocumentBeforeClose Event | DocumentBeforePrint Event | DocumentChange Event | DocumentOpen Event | NewDocument Property