copy file names from explorer to paste into excel

Anonymous
2009-06-30T14:00:06+00:00

I am trying to copy a long list of file names in file explorer and paste them into excel so I can keep track of file status, is there an easy way to do this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Hal Hostetler MVP-Outlook 12,011 Reputation points MVP Volunteer Moderator
2009-06-30T22:52:55+00:00

Thereare a number of ways to print Directory listings detailed here:

Print directory - Vista Forums

Hal

-- 

Hal Hostetler, CPBE

Senior Engineer/MIS -- MS MVP-Print/Imaging -- WA7BGX

www.kvoa.com -- KVOA Television, Tucson, AZ. 

Live at Hot Licks - www.badnewsbluesband.com

Was this answer helpful?

10+ people found this answer helpful.
0 comments

45 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2013-10-04T11:23:07+00:00

    can't seem to use my mouse in the command prompt window...

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-09-06T17:15:22+00:00

    Thank You So Much... Broxi I appreciate..

    I am doing video project in .net .. and it helps me to save the correct video file name for processing..

    Thanks DON

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-06-04T23:58:38+00:00

    You could always write a VBA procedure.

    Sub DirList()

        Dim FSO As Object

        Dim FF As Object

        Dim F As Object

        Dim R As Range

        Dim FullName As Boolean

        FullName = True '<<< #1 True to include directory name, False for name only.

        Set R = Range("A1") '<<< #2 Start cell of file list

        Set FSO = CreateObject("Scripting.FileSystemObject")

        Set FF = FSO.getfolder("G:\A") '<<< #3 Change to folder name

        For Each F In FF.Files

            If FullName = True Then

                R.Value = F.Path

            Else

                R.Value = F.Name

            End If

            Set R = R(2, 1)

        Next F

    End Sub

    Change the line marked with <<< #1 to True to include the folder name or False to include only the file name (no path info). Change line <<< #2 to the cell in which the list of files is to begin. Change the line marked with <<< #3 to the folder name whose files you want to list.

    I have an add-in that does this and much, much more.  See http://www.cpearson.com/excel/FolderTree.aspx for details.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-06-04T19:56:24+00:00

    How do you copy this list in CMD?

    I used PowerShell to do it... Ctrl-C seemed to work like 1 out of 7 tries.. not sure why it doesn't always work.

    Was this answer helpful?

    0 comments