More of this Feature • Part 1: Using VBA with Microsoft Word • Part 3: The AboutVBA.DOC Code Sample • Part 4: Word Objects • Part 5: The Automated Tutorial Review Program • Part 6: Using Toolbox Components

Join the Discussion Create a brilliant VBA app? Tell Us About It!

Related Resources • Segment One of the VBA Tutorial • The About Visual Basic Subjects List • Beginning Visual Basic • Visual Basic 6

From Other Guides • About Desktop Publishing for MS Word • About Business Software

Elsewhere on the Web • MS: Word Objects • MS: Templates vs Add-In's

There are lots of applications that are possible now that you know how to do this. For example, if you use Word mainly to write letters and only occasionally for something else, you could write an AutoExec program to ask whether to load a default "personal letter" or the generic Word environment.

Public Sub AutoExec()
   Dim MsgBoxResult
   Dim SaveFileName
   MsgBoxResult = _
      MsgBox("Click Yes to load the default letter" _
      & vbCrLf & "Click No to load default Word.", _
      vbYesNo, "Document Environment")
   If MsgBoxResult = vbYes Then
      Documents.Open _
         ("C:\DefaultLetter.doc")
         SaveFileName = _
            InputBox("Enter a name for the letter", _
            "Letter Name ?")
         If SaveFileName <> "" _
            Then ActiveDocument.SaveAs (SaveFileName)
   End If
End Sub