Copying file names and not the actual file

J

Justin Barker

I have a folder in Excel which contains about 500 files
with different file names refering to a different client:
e.g. "Proforma Bill Smith-GS010203" "proforma John Smith-
CS010302"
I am currently tying to set up an Excel spreadsheet and
would like to copy just the file names into the
spreadsheet - not the actual file.
I have been trying to copy and paste, just the file titles
and had no luck, as excel only wants to copy the file.
In Excel you can "Copy" and "Paste Special" if you want to
just copy the values, and I wondered whether you could do
the same for file names?

Help!!!

Justin - UK
 
Top