View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phil1982
 
Posts: n/a
Default 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