Occasionally I am also active in the French Microsoft Office TechNet forum, on one hand to practice my French and on the other hand just out of curiosity. Some time ago, someone asked there whether it is possible to retrieve a list of all trusted documents of Word 2010.
Unfortunately the Trust Center of Office 2010 does not offer a possibility to see which documents have been added to the trusted list of documents.
So I had the idea to implement a free Excel Add-In and list all trusted documents in an Excel sheet. And, when I am at it, I thought it should be a good idea to implement a function for listing all trusted folders too. And I should include the trusted documents and folders for PowerPoint, Word and Excel from Office 2007 and Office 2010.
I firstly implemented a German version of the Add-In and published it on my German Blog. Today, I translated the Add-In to English and I am happy to publish these versions here.
On its launch, the Add-In firstly checks whether Office 2010 and/or Office 2007 are installed. If Excel, PowerPoint and Word are found, then the checkboxes for the category are enabled and can be selected. The category “Actions” allows to specify if the trusted folder and/or the trusted documents may be retrieved. Of course, the feature for trusting documents is not available in Office 2007. So, if only Office 2007 is installed, then the checkboxes for searching for the trusted documents are disabled.
If you click on the red arrow on the lower left side of the dialogue, you will reach the next page. If the option “List trusted folders” is checked, the Add-In will automatically scan the Windows registry for the trusted folders for the previously selected applications.
Clicking again on the red arrow leads you to the next page for scanning the trusted documents; of course only if the options were checked on the first page of the dialogue and Office 2010 is installed. The scan also starts immediately.
Please note, that the Add-In only searches for the trusted documents from the user who is currently logged on the system. I am not planning to extend the Add-In with functions for searching the trusted documents for other users. So, if you need the list of trusted documents for another user, you may login with this user credentials.
The next page leads to the report features of the Add-In. Currently, only the option for creating a new workbook is active; I am planning to add the possibility to choose a template in the next versions of the Add-In.
Just click on the icon with the small green arrows for creating the report. That’s all, the Add-In creates one sheet for the trusted documents and one sheet for the trusted folders.
As mentioned before, the Add-In is free. However, on its first launch, a dialogue is displayed including the license terms which may be accepted. An important point is that, if you are using the Add-in, this gives you no rights to one of my trademarks or to the documentation and icons included. And, I assume no liability for damages of any kind and no warranty is given. The use is at your sole risk.
The Add-In was tested in Windows 7 and Excel 2003, Excel 2007 and Excel 2010 in the three languages German, English and French. As the Add-In uses some Windows 32 Bit API functions and controls, the Add-In will not run on a pure 64 Bit system.
I have not tested the Add-In on more systems; so if you are using it for the first time, I recommend to not have open important documents when using it. If you like to give me feedback, suggest new features or if you find a bug, please feel free to post a comment here or contact me via e-Mail to the e-Mail address mentioned on the imprint page of this blog. Finally the download link for the Add-In.