Can I make a spreasheet that lists every file in a direcory?

P

Phil1982

Hi

I've got a directory with 100's of files in it.
I want to make a spreadsheet which lists the name of each file.

The first solution i guessed was:
In My Computer- Select all - Edit Copy
In Excel - Edit Paste Special

But paste & paste special aren't options


Does anyone know a way I can do this? or do I really have to do it all
manually?


Thanks
 
P

Phil1982

Cheers Dave

You've saved me from loads of work!

I've gone with the DOS option instead of downloading any add ins



Phil
 
Top