The TM Directory Listing add-in, with over 4,000 downloads in the last 12 months, creates a table in Microsoft Excel of all the files and folders (also known as directories) in a specified directory. Several options control what is shown and it includes the capability of creating a outline. The result is easily extended to add hyperlinks or sort the data in different ways or filter the data according to custom requirements.
A typical table looks as shown in the 2 images below.
With the outline feature enabled, the result looks as below.
Thx TM for your Add In
I have installed the TM Directory add in. The TM Ribbon only displays Register and About. The Directory Listing dialogue box is not displayed. What am I doing wrong
Hi Tim,
Thank you for your interest in the add-in.
The Register (and About) choices are only in the dropdown for the main button. If you can click on the dropdown and see the Register button, you should also be able to click on the ‘Directory Listing’ button itself.
Doesn’t seem to work with Excel 2010. Excel Immediately goes to “Not Responding” whenever it is run.
Update: It does work, its just so slow with a large directory that it appears to freeze Excel
Hi WJ,
Thank you for your interest in the add-in. The performance, by its very nature, is limited by how fast the add-in gets the necessary information from Windows.
The code has seen several optimizations to improve performance and the latest version includes a dialog box that displays the directory that the add-in is currently processing together with a ‘Cancel’ button to cancel the currently running directory listing.
How do you add to the list?
If I understand you correctly, in the dialog box there is a field in which you can specify the cell where the new listing should start.
I’m having trouble installing. The self-install feature only installs 2 files – and they are uninstall files (unins000.dat and unins000.exe). Advice?
Hi LL: The other files should be in the add-ins directory. If they are not there it is possible that the security settings (enforced by Group Policy) disallowed the installation.
But, before we jump to that conclusion, it is quite likely that the files are there and you only have to enable them. This is *intentionally* not done automatically because, well, because I hate it when someone else changes settings, particularly those associated with security, on my computer.
You may want to check
Common Installation Instructions for Office add-ins
http://www.tushar-mehta.com/excel/software/installation/index.htm
Hi,
Is it possible to get other folder properties (i.e. “owner” etc)?
Addin looks great. Will definately be purchasing for myself – suggesting for our organisation.
Thanks.
Hi Brendan,
Thank you for your appreciation of the add-in.
I am looking into adding additional properties. The two big concerns are what properties of what kinds of files should the add-in include and the performance impact of retrieving this additional information.
Whatever I can do I will. However, no promises as to when, or even if, that will happen.
This plugin is great! Does even more than I needed, really nicely polished. My only question: is there any chance of making a version for Macs? I understand this would likely be quite an undertaking given the differences, but just thought I’d ask! The Windows version works great, but we run all Macs in my office so I’m forced to run this on our accounting laptop.
Thank you for the compliment. I hope to make it available on the Mac OS but as you’ve realized there are some incompatibilities between Windows and Mac OS that I have to resolve. So, while I hope to make this add-in available for Mac OS, no promises as to when or even if.
In theory, this add-in looks exactly like what I need. I downloaded it (Excel 07), but when I add it to the ribbon, I do not get any options with it, only the Directory Listing Register choice. Any ideas?
Thank you for your interest in the add-in.
The Register (and About) choices are only in the dropdown for the main button. If you can click on the dropdown and see the Register button, you should also be able to click on the ‘Directory Listing’ button itself.
If none of the buttons work, you may have to check your security settings. See
Common Installation Instructions for Office add-ins
http://www.tushar-mehta.com/excel/software/installation/index.htm
Wow, that easy… I must be having a blonde moment. Thanks for your help!
You are welcome.
Could you make it a select able option to only map the folders and not all of the files?
Hi Brandon,
The option is already in the add-in. In the TM Directory dialog box, check ‘List directories’ and uncheck ‘List files’
I have a directory structure that is more than 8 levels deep. The outline only goes to 8 levels. Is there a way to make it so that all levels are in the outline?
Hi Jonathan, The 8 level limit is an Excel limit, one that, as far as I know, is not extendible.
You made my day!
Though I was only able to get it working in Excel 2003, but nevermind.
Thanks for that.