How can i copy and paste file names?

Question

say i have a folder containing many files (jpg) and other folders containing (mp3, amr, mid, mpeg) and i want to copy only the files' NAMES and paste them in an excel sheet.
i have like thousands of files and i cant copy each name at a time, its gonna take ages, so anybody knows how to copy all names at one time, or any easier solution u can provide?
thnx

Answer 1

CopyFilenames is an extension for Windows Explorer. It cannot be run as a standalone application. After installing CopyFilenames, right click on one or more files or folders in Windows Explorer and you will see the extra commands added by CopyFilenames.

What's it for?
Windows has no built in way to copy a filename or folder listing to the clipboard. For a single file, you can use File > Rename, CTRL+C, then ESC to copy a filename to the clipboard, but this is quite tedious if you have to do this frequently or for lots of files.

CopyFilenames comes to the rescue! This adds an extra menu command to the context menu in Windows Explorer (this is the menu that pops up when you right click on a file). This command lets you copy the filename in one operation.

CopyFilenames can also be used to copy lots of filenames all in one go. By default, the filenames will be copied one per line

hey 10 bucks enjoy!

Answer 2

you can create a text file with all your filenames:

on windows XP, open Start Menu and click on Run... (or use Windows-key + R)
enter (without quotes) "CMD"
go to the directory of your choice (for exemple, if the directory containing your file is "D:\mp3s\some artist", enter :
d:
cd "d:\mp3s\some artist"
here, you can use the "dir" command to create a text file:
dir /b > list.txt
this will create a "list.txt" file containing the filenames for the current directory.


----- OR
you can directly create a macro inside Excel: create a new excel document (be sure to have only the new document open in Excel so that you won't mixed up macros within differents documents), open Visual Basic Editor (Tool > Macro > Visual Basic Editor)
copy/paste the following macro (between Private Sub... and End Sub) replacing "C:\Temp" with the directory of your choice (without final "\") and run it. It will read all files inside the directory and display the filename on your sheet

Private Sub ListFiles()

Dim BaseDir As String

BaseDir = "C:\temp"

With Application.FileSearch
.LookIn = BaseDir
.FileName = "*.*"
If .Execute() > 0 Then
NbFics = .FoundFiles.Count

For i = 1 To NbFics
Cells(i, 1).Value = Mid(.FoundFiles(i), Len(BaseDir) + 2)
Next i
Else
MsgBox "No File."
Return
End If
End With
End Sub

Answer 3

The easiest way as you described is by getting ASAP Utilities for Excel
http://www.asap-utilities.com/download-asap-utilities.php
it's a Free addon for Excel, after u install it, you'll see in the menu of Excel under ASAP, in the Information section "List Filenames in Folder"
That will do EXACTLY what you want to :)

Answer 4

you simply copy a file name and paste in a excell sheet.

Answer 5

Hi Yasmine

you can try this with few modifications

http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb05/hey0218.mspx

Hope it helps...good luck