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

Problem :want to copy data into EXCEL from Folder !!!

  • 07-04-2007 5:17pm
    #1
    ublinina2
    Closed Accounts Posts: 62 ✭✭


    I have a folder that contains lots of file names . I wish to copy these file names into an excel spread sheet as i want to create a sheet so that i can tabulate how much time i spent on each file.

    In the windows folder the file names are contained as such:
    Address Bar is : C:\mydocuments

    Name Size Type Modified

    Case 1 11 KB Microsoft Word Document 7/4/07
    Case 2 12 KB Microsoft Word Document 6/4/07
    Case 3
    Case 4
    ....
    ....

    etc.

    Now I want to take all that Information and put it into an excel spreadsheet so that i have
    Col A Col B Col C Col D
    Name Size Type Modified



    I can put in another column for the time I have spent

    I can print the data out by using the print screen and copying into word , but how can i copy the file names into Excel ??? ( I dont want to type them all in as there is loads of them).

    If you can suggest anything I would be grateful!!!!


Comments

  • #2
    cgf
    Closed Accounts Posts: 545 ✭✭✭cgf


    http://www.primeoption.com.au/FreewareYourDir.htm

    will allow you save to a csv file which can be then imported into Excel. I am sure there are fancier utilities but this does the basics.


  • #3
    zod
    Closed Accounts Posts: 2,025 ✭✭✭zod


    cmd prompt, navigate to root of folder

    dir *.* >myfiles.txt

    this creates a file called myfiles.txt

    copy the content of the new file into a column in excel, use the "text to columns" option under the tools menu to seperate file names from other info.


  • #4
    ublinina2
    Closed Accounts Posts: 62 ✭✭ublinina2


    zod wrote:
    cmd prompt, navigate to root of folder

    dir *.* >myfiles.txt

    this creates a file called myfiles.txt

    copy the content of the new file into a column in excel, use the "text to columns" option under the tools menu to seperate file names from other info.


    I typed in the cmd and got the prompt . The files that i want to open and copy is in My Documents\ Accounts.

    How do I open this in the cmd prompt and could you write out what i would write for the dir * . * > myfiles.txt

    When i create myfiles .txt , in which folder is this file located ?


  • #5
    xebec
    Registered Users, Registered Users 2 Posts: 3,311 ✭✭✭xebec


    You need to change the current directory that the command line is looking at.

    Open the folder in windows.
    Copy the path to this folder.
    Open the command line.
    Type cd followed by a space then paste (Ctrl+v) the path to the folder.
    Hit Enter/Return.

    Then follow what is said above.

    The file, myfiles.txt, should then be in the same folder as you were working on.


  • #6
    zod
    Closed Accounts Posts: 2,025 ✭✭✭zod


    ublinina2 wrote:
    How do I open this in the cmd prompt

    cd \
    cd "document and settings\my profile(replace)\my documents\accounts"
    ublinina2 wrote:
    and could you write out what i would write for the dir * . * > myfiles.txt

    dir *.* >myfiles.txt ( don't add in spaces )
    ublinina2 wrote:
    When i create myfiles .txt , in which folder is this file located ?

    in the folder that you run the command from.
    If you wanted you could say: dir *.* >c:\myfiles.txt

    which would leave it on the root of c:\


  • Advertisement
Advertisement