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:
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.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (10223) applies to Microsoft Word 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Word here: Listing Documents with Passwords.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Word allows you make two types of automatic backups of your documents. One is a copy of the file before you start making ...
Discover MoreWhen you organize your hard drive, it is easy to go hog-wild with folders and subfolders. You need to know that how you ...
Discover MoreIf you use TrueType fonts frequently, you might want to set Word to embed those fonts by default. Here's how to do it.
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2016-07-18 19:55:38
Michael
It seems so obvious after being laid out in a clear design.
What I'd like to know is how Step #1 works. Where do I find the info on how to open a file with a password, and how to detect that it did or didn't open?
I looked through the T of C (as well as possible--way too much to really scan) my new WordTips Macro book, and didn't see that covered.
Thanks
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
Comments