Resting Anchor

The Anchorage

Personal website of Gregory K. Maxey, Commander USN (Retired)

List Files in Folder
(A Microsoft Word Help & Tip page by Gregory K. Maxey)

DISCLAIMER/TERMS OF USE

The information, illustrations and code contained in my "Microsoft Word Tips" are provided free and without risk or obligation.

Click to acces PayPal Verification Service Click to acces PayPal Verification Service

However, the work is mine. If you use it for commercial purposes or benefit from my efforts through income earned or time saved then a donation, however small, will help to ensure the continued availability of this resource.

If you would like to donate, please use the appropriate donate button to access PayPal. Thank you!


This Microsoft Word Tips & Microsoft Word Help page provides a VBA template add-in solution for the task of listing files and selected file data located in any folder and sub-folders. You can use it to create a list of files in your favorite folders, flash thumb drives, or floppy discs.

The project is a collaborative effort by me, Word MVP Graham Mayor, and Excel MVP Andy Pope. Graham gets credit for dogged development reviews and criticism which led to many improvements. Andy Pope's class to emulate control tip text on Userforms "What's this help" and his suggestions for adapting it to include frame controls adds control tip enhancements to the Word 2007 version of the add-in.

I have prepared two versions of the add-In that you can download here: List File Templates. Both versions can be loaded manually as Word template add-ins or be placed in the Word Startup folder as a global add-in. The Word2003 version also works in Word2007 but does not contain the control tip enhancements. The user interface with the add-ins are shown below:

list file1
 .dot add-in displayed in Word 2003

list files 2
.dot add-in displayed in Word 2007

list files 3
.dotm add-in displayed in Word 2010

Clicking on the user interface command opens the add-in user interface (UI) shown below. With this interface you type in or browse for the folder you wish to process. You have the option to list only files in the selected folder or files in the selected folder and any files contained in sub-folders of that folder. In addition to listing all files, you can filter the listing to show only Office type files, and select the scope of file data included in the list. When you have selected your options you simply press the "Create List" command.

list files 4         list files 5

Site Note IconNote:  The UI is virtually the same.  The Word 2007/2010 version (developed later) has an enhance userform screen tip feature which is activated using the "?" control shown in the bottom right corner.

list files 6

After selecting the options and clicking "Create List", Word generates a new formatted document listing the file information as selected with the options.

list files 7

While testing the Word 2007/2010 version of this add-in, I learned that I couldn't create multi-line control tooltip text I dunno icon. I wanted users to be aware that selecting "Include Sub-Folders" could be problematic.

To solve this issue I took two routes (hence the two versions of the add-in). The Word 2007 version contains an enhanced control tooltip feature made possible by an interesting and brilliant Class module developed by Andy Pope. With Andy's assistance, I customized this module for use in the add-in.

The User Interface includes a "?" command button that activates the feature. When you click the command, then click a User Interface control, enhanced control tool tip text can be displayed.

list file 8
Word 2007/2010 Enhanced Tooltip

The Word2003 version provides an alternate means of displaying enhanced tooltip text and offers a registry setting option to suppress repeated displaying the tip. When you click on the "Include Sub-Folders" control a second Userform is displayed with enhance tooltip text. This Userform displays each time the control is selected. You can suppress displaying the Userform by checking the control shown.

list files 9

Site Note iconFor more on template add-ins and how to load them, see the heading: Organizing Your Macros/Template Add-ins at: Installing Macros

That's it! I hope you have found this tips page useful and informative.

Share Stumbleupon

PAYMENTS/DONATIONS

Click to acces PayPal Verification Service Click to acces PayPal Verification Service

Do you want to make a payment for consulting work or donate to help support this site?

PayPal is a safe, easy way to pay online.

Use the appropriate currency "Donate" button to make a payment or donation.


Search my site or the web using Google Search Engine

Google Search Logo

Or

JustAnswerAsk a Word Expert OnlineSubmit