rahela,

Or you could use my Excel add-in "List Files".
Comes with one page Word.doc install/use instructions.
Very easy to use and available - free - upon direct request.
(remove xxx from my e-mail address)

Regards,
Jim Cone
San Francisco, CA
XX

"rahela " wrote in message
...
I need to get into an excel worksheet the results of a dir
function, (including sub directories), so that on the first coloumn
let say A will be the directory (including the sub directories),
on coloumn B the file name, and on coloumn C the file extention,
on coloumn D the file size and coloumn E the date the file was
changed.
My OS is windows XP and my excel ver is 2000.
The type of files should not include hidden files of system files :)
Thanks for the help
rahela