Article ID: 184984
Article Last Modified on 1/22/2007
APPLIES TO
- Microsoft Word 97 Standard Edition
- Microsoft Word 2000 Standard Edition
- Microsoft Word 2002 Standard Edition
- Microsoft Office Word 2003
This article was previously published under Q184984
SYMPTOMS
When you use the Microsoft Visual Basic for Applications (VBA) dialogs collection and set a password for a document, the password is not saved with the document.
CAUSE
This problem occurs when you use the wdDialogFileSaveAs dialog box constant to display the FileSaveAs dialog box, and then set the password for a document while the File Save As dialog box is displayed.
WORKAROUND
Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact a Microsoft Certified Partner or the Microsoft fee-based consulting line at (800) 936-5200. For more information about Microsoft Certified Partners, please visit the following Microsoft Web site:
For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:
The command line that you typiclly use to display the File Save As dialog box is as follows:
Dialogs(wdDialogFileSaveAs).Show
To display the File Save As dialog box and to save a password that you set, use the following macro commands instead of the Dialogs(wdDialogFileSaveAs).Show macro:
Sub SaveDocPasswordWorkAround() Dim dlg As Dialog Dim dlgParm As String Dim x as Integer 'Returns the values of the FileSaveAsDialog when displayed ' If no documents are open to save, then exit this routine. If Documents.Count = 0 Then Exit Sub End If ' Set object variable to the File Save As dialog box. Set dlg = Dialogs(wdDialogFileSaveAs) ' Display the dialog box. dlg.Display ' Extract the name to save as (typed into the File Name text box.) dlgParm = dlg.Name ' Force an update to the dialog box. dlg.Update ' Reset the file name. dlg.Name = dlgParm ' If x = -1 user clicked Save on the FileSaveAs dialog. If x = 0, user clicked Cancel. ' Execute the dialog box commands. If x = -1 Then dlg.Execute End If End Sub
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem has been corrected in Word 2000.
MORE INFORMATION
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
173707 OFF97: How to run sample code from Knowledge Base articles
For additional information about how to recieve help with VBA, click the following article number to view the article in the Microsoft Knowledge Base:
163435 VBA: Programming resources for Visual Basic for Applications
Additional query words: wordcon vb vba WD97
Keywords: kbbug kbdtacode kbpending KB184984