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

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

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

From a recent discussion...
http://groups.google.com/group/micro...5b1cc065da 7b

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

Cheers Dave

You've saved me from loads of work!

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



Phil

"Dave O" wrote:

From a recent discussion...
http://groups.google.com/group/micro...5b1cc065da 7b