+ Reply to Thread
Results 1 to 3 of 3

windows explorer to excel

  1. #1
    Registered User
    Join Date
    12-22-2003
    Location
    Texas
    Posts
    90

    windows explorer to excel

    I know this is not excel specific, but does anyone know a good way to export the file names and properties of a folder in windows explorer to an excel file? For example, I want to create a CSV file that has in it's columns the file name, file size, type, date modified, etc. I would imagine that there would be a utility in windows explorer, but i have looked with no success. Is there an aftermarket product that will do that?
    Barrfly

  2. #2
    Registered User
    Join Date
    07-26-2005
    Posts
    5

    RE: windows explorer to excel

    I came across this a few months ago. Hope it Helps

    http://www.exceltip.com/st/List_file...Excel/446.html

    Odie

  3. #3
    Earl Kiosterud
    Guest

    Re: windows explorer to excel

    barrfly,

    Try it at the command line (Start - Programs - cmd.exe). Long-toothed folks
    will call it "DOS." Once there, try something like

    DIR > myfile.txt

    Type exit at the command line, or click the X, when you're done with the
    "DOS box."

    Pay attention to the path (C:\Documents and Settings\ etc.) -- that
    determines the folder where the file will be written to. myfile.txt should
    exist after running the DIR command above. It won't be comma-delimited, but
    you could open it with Excel and get it converted to a proper
    comma-delimited file, if necessary.
    --
    Earl Kiosterud
    www.smokeylake.com

    "barrfly" <[email protected]> wrote in
    message news:[email protected]...
    >
    > I know this is not excel specific, but does anyone know a good way to
    > export the file names and properties of a folder in windows explorer to
    > an excel file? For example, I want to create a CSV file that has in
    > it's columns the file name, file size, type, date modified, etc. I
    > would imagine that there would be a utility in windows explorer, but i
    > have looked with no success. Is there an aftermarket product that will
    > do that?
    >
    >
    > --
    > barrfly
    >
    > Excel User - Energy markets
    > ------------------------------------------------------------------------
    > barrfly's Profile:
    > http://www.excelforum.com/member.php...fo&userid=4141
    > View this thread: http://www.excelforum.com/showthread...hreadid=390576
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1