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

Printing On Both Sides of the Paper

Turning Off AutoComplete for Dates

Ordering Search and Replace

Understanding Auto Line Spacing

Adding Comments to Your Document

Conditional Calculations in Word

Determining Word Frequency

 

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

Step Up and Take Control! Subscribers to WordTips know just how valuable a resource it is. WordTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on WordTips archives and e-books.
 
Check out WordTips Premium today!