Word.Tips.Net Welcome toWord.Tips.Net

Helpful Links

Tips.Net Home
WordTips Home

Ask a Word Question
Make a Comment

Tips.Net Store

WordTips FAQ
WordTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
WordTips Site

Newest Tips

Arranging Document Windows

Specifying a Backup Location

Controlling Chart Gridlines

Merging Table Cells

Collapsing and Expanding Subdocuments

Zooming With the Keyboard

Initiating a New Search

 

Listing Documents with Passwords

Summary: Do you need a list of documents that require a password or that require a particular password to open? Word doesn't provide a way to retrieve such information, but you could do it with a macro. This tip describes the approach that should be used if you decide to develop such a macro. (This tip works with Microsoft Word 97, Word 2000, Word 2002, and Word 2003.)

Jamie asked if it is possible to get a list of all passworded Word documents, or all documents using a particular password. The short answer is "No, Word doesn't have such a capability." Passwords are saved with a document, and if you don't know the password (or cannot guess a password), then you cannot open a document. Period.

The longer answer is that if you know what passwords you were personally most likely to use on a document, then you could write a macro that would attempt to open your documents using those passwords. The macro could follow these general steps:

  1. Try to open a document using the various passwords.
  2. If successful, keep track of the document name and password used.
  3. If unsuccessful, keep track of the document name.
  4. Repeat steps 1-3 for each document.
  5. Present a list of documents opened with each password.
  6. Present a list of documents unable to be opened with the supplied passwords.

Note that this approach will only work if you already know the possible passwords. For instance, if you have three or four passwords you typically use, then you could use these steps to test documents with those likely passwords. If a particular document doesn't use one of those passwords, then you are out of luck--the document will just be considered "unopenable" in step 3 and listed in step 6.

Tip #1617 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003

Save Time! WordTips has been published weekly since early 1997. Past issues are available in convenient WordTips archives. Have your own enhanced archive of WordTips at your fingertips, available to use at any time!
 
Check out WordTips Archives today!