Results 1 to 6 of 6

Thread: listing files/folders in a document

  1. #1
    2nd hardest inthe infants petrefax's Avatar
    Join Date
    Jul 2003
    Location
    cardiff
    Posts
    1,149
    Thanks
    13
    Thanked
    13 times in 13 posts

    listing files/folders in a document

    i'm sure this has been asked before, but i have a folder with 1000's of documents in it (returned user forms - file name is the users name) & i'd like to produce a list of all the documents which can be displayed in word / excel (preferably excel so i can sort & filter etc)

    any way of doing this....better still any utilities that'll do it for me

    cheers
    if it ain't broke...fix it till it is


  2. #2
    '~'+'~' Enverex's Avatar
    Join Date
    Oct 2003
    Location
    West Midlands
    Posts
    904
    Thanks
    0
    Thanked
    0 times in 0 posts
    • Enverex's system
      • Motherboard:
      • Gigabyte H77n-WiFi
      • CPU:
      • Intel i5-3570K with Scythe Shuriken
      • Memory:
      • 16GB Crucial Ballistix Tactical 1600Mhz
      • Storage:
      • Samsung 840 500GB SSD
      • Graphics card(s):
      • MSI GTX 670 2GB OC Power Edition
      • PSU:
      • EVGA SuperNOVA 550W G2
      • Case:
      • Silverstone Sugo SG11
      • Operating System:
      • Windows 10 Pro 64bit
      • Monitor(s):
      • LG 42LW550T 42" TV
      • Internet:
      • BT Infinity
    One quick way of doing it it opening a command promt, navigating to the folder and typing this...

    dir > whatever.txt

    And just rename whatever to what you want it called. It will basically output the response into that file, and you should be able to import/convert it into excel split into different cells.

    NS

  3. #3
    I can't get no sleep
    Join Date
    Jul 2003
    Location
    123 Fake Street, London
    Posts
    811
    Thanks
    35
    Thanked
    3 times in 3 posts
    If the dir command does not do everything you need then I have used this program. It can search for specific file types as well as allowing you to specify the depth of sub-directories to search. There are probably newer more fancy programs out there, but I find this programs simple interface makes it quick to use.

    http://www.tawbaware.com/filelist.htm

    The text file output should import into Excel easily since each entry is on a new line. Excel will treat each new line as a new row.
    Last edited by Anders; 23-11-2003 at 03:30 AM.
    "Keyboard missing - press F3 to continue" Message seen on an Apricot PC.
    "To start press any key. Where's the any key?" Homer Simpson.
    Hexus Trust

  4. #4
    Senior Member
    Join Date
    Aug 2003
    Location
    Chesterfield
    Posts
    1,436
    Thanks
    4
    Thanked
    5 times in 5 posts
    dir > whatever.txt wont give you contents of subfolder however, use dir >whatever.txt/s for that

  5. #5
    2nd hardest inthe infants petrefax's Avatar
    Join Date
    Jul 2003
    Location
    cardiff
    Posts
    1,149
    Thanks
    13
    Thanked
    13 times in 13 posts
    excellent!!! - i'll be spending this afternoon in work trying these out
    if it ain't broke...fix it till it is


  6. #6
    Ex-MSFT Paul Adams's Avatar
    Join Date
    Jul 2003
    Location
    %systemroot%
    Posts
    1,926
    Thanks
    29
    Thanked
    77 times in 59 posts
    • Paul Adams's system
      • Motherboard:
      • Asus Maximus VIII
      • CPU:
      • Intel Core i7-6700K
      • Memory:
      • 16GB
      • Storage:
      • 2x250GB SSD / 500GB SSD / 2TB HDD
      • Graphics card(s):
      • nVidia GeForce GTX1080
      • Operating System:
      • Windows 10 x64 Pro
      • Monitor(s):
      • Philips 40" 4K
      • Internet:
      • 500Mbps fiber
    And if you're not bothered about the file details (date, size, etc.) then type dir /b (or dir /b /s to recurse through subdirectories too)
    ~ I have CDO. It's like OCD except the letters are in alphabetical order, as they should be. ~
    PC: Win10 x64 | Asus Maximus VIII | Core i7-6700K | 16GB DDR3 | 2x250GB SSD | 500GB SSD | 2TB SATA-300 | GeForce GTX1080
    Camera: Canon 60D | Sigma 10-20/4.0-5.6 | Canon 100/2.8 | Tamron 18-270/3.5-6.3

Thread Information

Users Browsing this Thread

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

Posting Permissions

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