Skip to content
 

TM Directory Listing

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.

23 Comments

  1. Tjharlez says:

    Thx TM for your Add In

    • Tim Cain says:

      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

      • Tushar Mehta says:

        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.

  2. WJ says:

    Doesn’t seem to work with Excel 2010. Excel Immediately goes to “Not Responding” whenever it is run.

    • WJ says:

      Update: It does work, its just so slow with a large directory that it appears to freeze Excel

      • Tushar Mehta says:

        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.

  3. Scop says:

    How do you add to the list?

  4. LL says:

    I’m having trouble installing. The self-install feature only installs 2 files – and they are uninstall files (unins000.dat and unins000.exe). Advice?

    • Tushar Mehta says:

      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

  5. Brendan says:

    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.

    • Tushar Mehta says:

      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.

  6. Danny says:

    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. :(

    • Tushar Mehta says:

      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.

  7. Nicole says:

    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?

  8. Nicole says:

    Wow, that easy… I must be having a blonde moment. Thanks for your help!

  9. Brandon says:

    Could you make it a select able option to only map the folders and not all of the files?

  10. Jonathan says:

    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?

  11. Gabe says:

    You made my day! :-)
    Though I was only able to get it working in Excel 2003, but nevermind.
    Thanks for that.

Leave a Reply