Results 1 to 12 of 12
  1. #1
    Lounger
    Join Date
    May 2002
    Location
    California, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy File Names (Windows XP)

    Does anyone know how (or of a simple utility) to copy File Names out of a folder to Excel. I have huge folders full of files that I need to keep lists of in Excel and sort in various orders for my boss. It is not enough to do a print screen and print them. I have tried doing that and then converting to pdf and using the column or text select tool but that doesn't work. Maybe there is an add- in? Thank You

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy File Names (Windows XP)

    For a method using VBA check <post#=198735>post 198735</post#>

    For an alternative approach see this John Walkenbach Excel user tip

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy File Names (Windows XP)

    A google search revealed a commercial add-in The Directory Lister for Excel

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy File Names (Windows XP)

    When you say "Copy file names", do you mean make a list of just the file names in a folder, not the (sub-)folder names?

    If yes, you can create a text file which can be read into Excel via "fixed columns", by going into a Command Prompt window, and running<pre>dir /b /a-d "C:Program Files" > dirlist.txt</pre>

    (obviously replacing "C:Program Files" by whatever folder name you want). If I do this on my XP PC for "C:" I get, in DIRLIST.TXT:

    AUTOEXEC.BAT
    BOOT.INI
    BOOTSECT.DOS
    CONFIG.SYS
    DELL.SDR
    hiberfil.sys
    IO.SYS
    MSDOS.SYS
    NTDETECT.COM
    NTLDR
    pagefile.sys

    Hope this could help!

    John
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Copy File Names (Windows XP)

    I'm with JohnGray. If you want more info than the /b option provides, but less than all of it, you can open the .txt file in Word, make sure it is assigned a fixed-width font like Courier and fits within the margins, and use the rectangular selection tool (Alt+click and drag) to select and delete unwanted columns. If it's something you need to update often, some kind of program that can reconcile the lists with the current reality would be a better bet, but "DOS" (or "command mode" or...) is fastest.

  6. #6
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Copy File Names (Windows XP)

    Karens "Directory Printer " will do this but in a text file.
    http://www.karenware.com/powertools/powertools.asp
    Directory Printer Print the names, and other information, of all folders and files on your computer

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  7. #7
    Lounger
    Join Date
    May 2002
    Location
    California, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy File Names (Windows XP)

    Thanks for all your help! I tried a few of the suggestions and found a freeware file called dirlister.exe that makes a quick text file that I can plug into Excel pretty nicely. You got me turned in the right direction. Thanks again.

  8. #8
    Plutonium Lounger
    Join Date
    Oct 2001
    Location
    Lexington, Kentucky, USA
    Posts
    12,107
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy File Names (Windows XP)

    If none of the above is of any help to you, I have an OLD <img src=/S/free.gif border=0 alt=free width=30 height=15> utility from PC Magazine that I haven't tried in Windows XP days, so it may be too old to do what you want. The link is still active, so you may want to give FileGrab a look-see.

    Edited later: I just tried FileGrab running under WinXP Pro (it requires no installation). Works just fine. You open a FileGrab window AND a Windows Explorer window. You can drag selected files to the FileGrab window, from one or MORE directories, building a "list" as you go. They can be from a single directory or several directories, if you like. When you're finished, click CTRL-A to highlight all the files in the FileGrab window, Save As a .TXT file which Excel will open, parsing the columns nicely.

  9. #9
    Plutonium Lounger
    Join Date
    Oct 2001
    Location
    Lexington, Kentucky, USA
    Posts
    12,107
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy File Names (Windows XP)

    Would you post the link for the benefit of other Loungers, please?

  10. #10
    Uranium Lounger
    Join Date
    Mar 2001
    Location
    New Jersey
    Posts
    6,684
    Thanks
    1
    Thanked 11 Times in 11 Posts

    Re: Copy File Names (Windows XP)

    They're new here. I found a link on Google that took me here. HTH <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    <IMG SRC=http://www.wopr.com/w3tuserpics/DocWatson_sig.gif>

  11. #11
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Quedgeley, Gloucester, England
    Posts
    5,333
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy File Names (Windows XP)

    You (may) need to beware that DIRLISTER truncates "fairly long file names" at 50 characters by default, unless you change the value in Option 1.

    John
    <font face="Script MT Bold"><font color=blue><big><big>John</big></big></font color=blue></font face=script>

    Ita, esto, quidcumque...

  12. #12
    Plutonium Lounger
    Join Date
    Oct 2001
    Location
    Lexington, Kentucky, USA
    Posts
    12,107
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copy File Names (Windows XP)

    This does look like a nice program. I went to the author's web site to see if I could read some more detail. The program seems to focus on directories and not individual files. One of the reasons I started using the PC Mag program (FileGrab) is that it lets you "build" a list of selected files in one or more directories. When I first came on it, I wanted a way, for example, to make a list of JPG files in different directories, selectively. FWIW.

Posting Permissions

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