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.
4th July 2008, 11:29 AM #1
- Rep Power
Add-in to get a directory listing into Excel
I've been looking for somthing to do this for years.
2 Thanks to SeanVin:
Heebeejeebee (4th July 2008), leco (4th July 2008)
4th July 2008, 02:38 PM #2
Have you tried it - does it work as you expected?
Originally Posted by SeanVin
4th July 2008, 02:43 PM #3
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.
5th July 2008, 12:06 AM #4
- Rep Power
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.
Originally Posted by leco
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.
By beeswax in forum How do you do....it?
Last Post: 22nd May 2008, 08:41 AM
By speckytecky in forum Wireless Networks
Last Post: 11th September 2007, 09:53 AM
By Geoff in forum Windows Vista
Last Post: 23rd February 2007, 02:07 PM
By wesleyw in forum How do you do....it?
Last Post: 20th December 2006, 01:38 PM
By indiegirl in forum Educational Software
Last Post: 24th July 2006, 11:50 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread