File Attributes

Please can anybody assist with listing File Attributes from a folder I need to list.
The following code is super quick at listing filenames but I need to show other file details.
Here is the code I am trying to use and am stuck trying to list the file Mb, Date, Length Attributes etc.

Please Login or Register  to view this content.

Many thanks.

Suggest using the file scripting object as described in

http://windowssecrets.com/forums/sho...m-VBA-in-Excel

Thank you for your suggestion, unfortunately it did not help me work out how to find one particular attribute, the file audio duration.
For anybody else looking at this thread, I did find help and have altered my code as follows.

Please Login or Register  to view this content.

Thank you to mrice for your assistance.