Just thought of another short cut:

Having got d:\myfile.txt, type the following command:

attrib < d:\myfile.txt d:\myfileatt.txt

The file d:\myfileatt.txt contains the attributes followd by the file names.
You'd need to use the file stystem Object to get the file sizes.

"J_J" wrote:

Hi,
Can we list the *.doc and *.xls files in all dir/sub directories of drive D:
which ARE protected by filename, loacation, size via VBA?
TIA
J_J