Occurs when a document is opened.
Private Sub object_DocumentOpen(ByVal Doc As Document)
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 opened.
This example asks the user whether to save all other open documents when a document is opened. 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_DocumentOpen(ByVal Doc As Document) Dim intResponse As Integer Dim strName As String Dim docLoop As Document intResponse = MsgBox("Save all other documents?", vbYesNo) If intResponse = vbYes Then strName = ActiveDocument.Name For Each docLoop In Documents With docLoop If .Name <> strName Then .Save End If End With Next docLoop End If End Sub