Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Directory listing software

  • 18-11-2010 06:18PM
    #1
    Theboinkmaster
    Registered Users, Registered Users 2 Posts: 4,161 ✭✭✭


    Hiya

    I'm sure this exists but can't find it. I'm simply looking for a way of compiling a list of the files in a directory, and putting it on excel.

    For example i have a HD with 800 films on it, all separate .avi files. I want to list these films out on excel or word.

    Any suggestions?


Comments

  • #2
    CiaranC
    Closed Accounts Posts: 6,300 ✭✭✭CiaranC


    Theboinkmaster wrote: »
    Hiya

    I'm sure this exists but can't find it. I'm simply looking for a way of compiling a list of the files in a directory, and putting it on excel.

    For example i have a HD with 800 films on it, all separate .avi files. I want to list these films out on excel or word.

    Any suggestions?
    simply type

    dir > file.xls

    in a dos window


  • #3
    CiaranC
    Closed Accounts Posts: 6,300 ✭✭✭CiaranC


    woops, that should read

    dir /b > file.xls


  • #4
    Theboinkmaster
    Registered Users, Registered Users 2 Posts: 4,161 ✭✭✭Theboinkmaster


    CiaranC wrote: »
    woops, that should read

    dir /b > file.xls

    Sorry im thick but how exactly do i do that? I'm running Vista.

    is /b the name of the directory and path? how do i copy to excel?

    Sorry:o


  • #5
    bhickey
    Registered Users, Registered Users 2 Posts: 1,340 ✭✭✭bhickey


    1. Go to a command prompt. In Windows Explorer, hold down shift and right-click and you will get the option to "Open Command Window Here." This will open a Command Prompt in the current directory. Otherwise you'd have to manually change directory within the command prompt screen to wherever the directory is on the drive.

    2. As above, type 'dir /b > filelist.txt'. This will create a file called 'filelist.txt' in the current folder with a filename (and nnothing else) .on each line.


  • #6
    Theboinkmaster
    Registered Users, Registered Users 2 Posts: 4,161 ✭✭✭Theboinkmaster


    bhickey wrote: »
    1. Go to a command prompt. In Windows Explorer, hold down shift and right-click and you will get the option to "Open Command Window Here." This will open a Command Prompt in the current directory. Otherwise you'd have to manually change directory within the command prompt screen to wherever the directory is on the drive.

    2. As above, type 'dir /b > filelist.txt'. This will create a file called 'filelist.txt' in the current folder with a filename (and nnothing else) .on each line.

    perfect thank you!


  • Advertisement
Advertisement