Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Application.DocumentOpen Event (Word)

Published: July 16, 2012

Occurs when a document is opened.

Private Sub expression _DocumentOpen(ByVal Doc As Document)

expression A variable that represents an Application object declared with events in a class module.

Parameters

Name

Required/Optional

Data Type

Description

Doc

Required

Document

The document that's being opened.

For more information about using events with the Application object, see Using Events with the Application Object.

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 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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.