Results 1 to 9 of 9

Thread: export filenames from folder

  1. #1
    Senior Member gavpk's Avatar
    Join Date
    Jan 2008
    Posts
    712
    Thanks
    29
    Thanked 37 Times in 12 Posts
    Rep Power
    224
    Reputation
    176

    Default export filenames from folder

    Hi,
    Does anyone know of a small program that will export all file names within a folder and place them in an excel doc?
    any help would be appriciated

    PS, i thought there was something posted before the crash, but cant remember the name.

    Gav



Look Here ->
  • #2
    Junior Member
    Join Date
    Jan 2008
    Location
    Central Vic
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    200
    Reputation
    10

    Default

    A bit late, but I just goto the folder in the command prompt and type
    dir /b > list.txt
    Then open list.txt in notepad and copy into excel

  • #3
    Senior Member gavpk's Avatar
    Join Date
    Jan 2008
    Posts
    712
    Thanks
    29
    Thanked 37 Times in 12 Posts
    Rep Power
    224
    Reputation
    176

    Default

    Quote Originally Posted by sericom View Post
    A bit late, but I just goto the folder in the command prompt and type
    dir /b > list.txt
    Then open list.txt in notepad and copy into excel
    yeah thanks, i ended up using this in a batch file, made a shortcut to the bat file and put it in "send to" folder, now i just right click any folder ,select sendto and click the batch shortcut, it opens up notepad withh all the file names
    --------------------------------------------------
    dir %1 /-p /a:-d /b /o > "%temp%\file List"
    notepad "%temp%\file List" erase "%temp%\file List"
    --------------------------------------------------

  • #4
    Junior Member
    Join Date
    Jan 2008
    Location
    Central Vic
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    200
    Reputation
    10

    Default

    That's even better, thanks mate.
    Is there a way to remove the extension?

  • #5
    Senior Member gavpk's Avatar
    Join Date
    Jan 2008
    Posts
    712
    Thanks
    29
    Thanked 37 Times in 12 Posts
    Rep Power
    224
    Reputation
    176

    Default

    i dont think so, but someone else may correct this

  • #6
    Member
    Join Date
    Jan 2008
    Location
    Super Duper Secret Members Forum
    Posts
    374
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Reputation
    21

    Default

    Yeah, after you dump the filename into excel you do "TEXT TO COLUMNS" and use . as your delimiter.

    Another way would be to use a formula like =left(len(a1)-4) in cell b1 of excel, assuming the extension is 3 digits preceded by a .

  • #7
    Junior Member
    Join Date
    Jun 2013
    Posts
    1
    Thanks
    0
    Thanked 3 Times in 1 Post
    Rep Power
    0
    Reputation
    40

    Red face

    Quote Originally Posted by sericom View Post
    A bit late, but I just goto the folder in the command prompt and type
    dir /b > list.txt
    Then open list.txt in notepad and copy into excel
    The only reason i registered here was to thank you for this post. I found it through Google a few weeks back, & it is the most useful Command Line feature I have found in years. Thank you very much!

  • The Following 3 Users Say Thank You to Moo For This Useful Post:

    lsemmens (09-06-13),Tiny (09-06-13),tristen (09-06-13)

  • #8
    Premium Member

    Join Date
    Jan 2008
    Posts
    4,311
    Thanks
    5,982
    Thanked 4,171 Times in 1,771 Posts
    Rep Power
    1348
    Reputation
    50392

    Default

    Quote Originally Posted by Moo View Post
    The only reason i registered here was to thank you for this post. I found it through Google a few weeks back, & it is the most useful Command Line feature I have found in years. Thank you very much!
    Thank YOU Moo for taking the trouble to join and to post your appreciation.

    Good manners is always appreciated. I wish that there were more like you. Unfortunately politeness and respect are disappearing at an alarming rate.

    Having said that, Welcome to Austech!

    Now that you have joined, please consider looking in from time to time. Perhaps you will be able to help others also. The forums cover a vast range of topics.

  • The Following 3 Users Say Thank You to tristen For This Useful Post:

    lsemmens (09-06-13),Tiny (09-06-13),weirdo (09-06-13)

  • #9
    LSemmens
    lsemmens's Avatar
    Join Date
    Dec 2011
    Location
    Rural South OZ
    Posts
    10,585
    Thanks
    11,867
    Thanked 7,061 Times in 3,338 Posts
    Rep Power
    3153
    Reputation
    132592

    Default

    I'm with Tristen, moo, what makes any forum great, is the contribution made by members such as yourself. I hope to see you here in future.

  • Bookmarks

    Posting Permissions

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