View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Diane Mallin[_2_] Diane Mallin[_2_] is offline
external usenet poster
 
Posts: 3
Default List the contents of a directory

I have a macro which will find a given directory - what I would like to be
able to do is to pick up a list of all the files in the directory and list
these in an Excel worksheet - starting at A1 and continuing down to A20 (if
there are 20 files listed in the directory)

Cheers

Gazza