+ Post New Thread
Results 1 to 4 of 4
Downloads Thread, Add-in to get a directory listing into Excel in Links, Downloads and Scripts; I've been looking for somthing to do this for years. Directory List...
  1. #1
    SeanVin's Avatar
    Join Date
    Dec 2006
    Location
    Northgate High School, Ipswich
    Posts
    80
    Thank Post
    29
    Thanked 13 Times in 9 Posts
    Rep Power
    19

    Add-in to get a directory listing into Excel

    I've been looking for somthing to do this for years.

    Directory List

  2. 2 Thanks to SeanVin:

    Heebeejeebee (4th July 2008), leco (4th July 2008)

  3. #2
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    42
    Quote Originally Posted by SeanVin View Post
    I've been looking for somthing to do this for years.

    Directory List
    Have you tried it - does it work as you expected?

  4. #3
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,067
    Thank Post
    69
    Thanked 81 Times in 64 Posts
    Rep Power
    36
    Nice,

    I do have a directory lister that does exactly the same job but you have to manually copy/paste into excel. This eliminates that step.

    Good find.

    HBJB

  5. #4
    SeanVin's Avatar
    Join Date
    Dec 2006
    Location
    Northgate High School, Ipswich
    Posts
    80
    Thank Post
    29
    Thanked 13 Times in 9 Posts
    Rep Power
    19
    Quote Originally Posted by leco View Post
    Have you tried it - does it work as you expected?
    Yes better than I expected as it gives folder sizes and last modified dates. There is no documentation, on my first couple of runs it failed because it ran out of rows. You need to be careful how many sub-directories levels you enter (-1 appears to be all of them), I also un-checked the 'list files' box. It can take a while to scan, It made me late leaving work! I was using Excel 2003 but I will try it with 2007 next week.

    One really useful feature is that the last column holds a 'Unique number'. No matter how you sort or chop out sections of the listing you can sort by 'Unique number' and restore the original tree structure.



SHARE:
+ Post New Thread

Similar Threads

  1. Disable directory listing
    By beeswax in forum How do you do....it?
    Replies: 8
    Last Post: 22nd May 2008, 09:41 AM
  2. Tools to use for listing network connections?
    By speckytecky in forum Wireless Networks
    Replies: 4
    Last Post: 11th September 2007, 10:53 AM
  3. Listing of Vista Drivers
    By Geoff in forum Windows Vista
    Replies: 2
    Last Post: 23rd February 2007, 03:07 PM
  4. Listing and terminating remote programs/processes
    By wesleyw in forum How do you do....it?
    Replies: 4
    Last Post: 20th December 2006, 02:38 PM
  5. Useful(?) to some - OSS listing on the web.
    By indiegirl in forum Educational Software
    Replies: 0
    Last Post: 24th July 2006, 12:50 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •