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.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
It is often helpful to have a list of all the documents in a given directory or folder. Word doesn't have a built-in way ...
Discover MoreWant to get rid of any properties you've created for a document? You can do so by using the short macro described in this ...
Discover MoreWhen you use Save As, it can be frustrating to be offered all sorts of locations in which to save your file. Fortunately, ...
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.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2022 Sharon Parq Associates, Inc.
Comments