Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Directory listing software

  • 18-11-2010 5:18pm
    #1
    Theboinkmaster
    Registered Users, Registered Users 2 Posts: 4,034 ✭✭✭


    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,034 ✭✭✭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,034 ✭✭✭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