Hi
have a look at
http://tinyurl.com/2y9e8

--
Regards
Frank Kabel
Frankfurt, Germany

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


---
Message posted from http://www.ExcelForum.com/