Recently, this thread 'Windows 10 Retrieving Extended File Properties'
raised issues about using the GetDetailsOf
method to retrieve extended file properties (attributes).
is a member of the VBA library 'Microsoft Shell Controls and Automation
' based on Shell32.dll
For anyone else who hasn't heard of this, each file includes several extended properties which can be retrieved as needed using this method.
• Date created / date modified / date last accessed
• File size / file type / author / location
Certain types of file will also contain additional extended properties including:
• Height / width / horizontal resolution / vertical resolution / bit size (image files)
• Contributing artist / album / year / genre / tile / track # / length / bit rate (audio files)
In all, there are a total of 311 extended properties though no files will ever use all of these
I decided to investigate this method further and have created a database which provides an easy way of obtaining and storing all the extended properties for an individual file or all files of a specified type in a selected folder.
The attached text files contain the full list of extended properties (attributes) & example output for an audio file
The zip file contains the database FileAttributes.accdb
, a PDF
file with full details and screenshots as well as several other text files with examples of the extended properties (attributes) obtained for different types of file
The database includes the VBA reference library 'Microsoft Shell Controls and Automation
NOTE: it also includes an example of a dynamic crosstab query where the column headers are automatically updated to match the underlying data
Any questions or suggestions, please send me a private message or email me using the address given in the PDF file