My starter scripts in January 2021:
List Excel file attributes in Excel
File attributes of Excel files (the file properties accessible on right-click) are seldom used to their full potential, in my experience. I suspect one reason for this is that there’s no quick way to see what details have been entered for multiple files.
Here’s a snippet that allows you to see the title, description, subject and other details (like date last modified) for multiple Excel files held in a single folder, all in one spreadsheet.
Check out tomorrow’s post for an easy way to update all file attributes for all Excel files in a folder, in a single click.
Any thoughts or questions, get in touch
Have a look at the code I used, here: