copy file names from explorer to paste into excel

I've seen lots of complicated ways to do this in this blog but the the easiest and best has to be to use the file navigation facility built into browsers OTHER THAN Internet Explorer.

Here is a fuller 'how to' explanation: 

Install Firefox browser if not already available.

Enter the appropriate disc drive into the address bar e.g C:\ (you can also use the full folder path in reverse slash format e.g. C:\Users\myname\Documents). Navigate down to the the folder required for copy.

A nice neat file list with size and date last modified is displayed.

CTRL A to highlight; CTRL C to copy.

Paste Special into Excel; select Text option (not HTML!); adjust (widen) column sizes.

There you have it;  the list can be sorted in Excel (e.g. by file name or date or size) but not in Firefox which always lists in alphabetical order.

Notes: 

1.  I've not tried it but should also work in Opera and Chrome;  but NOT Microsoft Internet Explorer which unhelpfully takes you back to Windows Explorer.

2.  It may be easier to navigate to the folder using Windows Explorer first (i.e. the file directory accessed from 'Computer').  Then copy the path from the navigate bar and paste to Firefox. If the bar displays in arrow seperated format, convert it to slash separated format by clicking on the folder icon at the start of the Windows Explorer navigate bar. 

3: To remove 'File:' from the start of each file name in the Excel listing do Find and Select; Replace; Find what: "File:"; Replace with nothing; Replace All.

No credit to me for working this out - I found the solution somewhere when I had the same problem.

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.

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.

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