I am struggling with finding a way to report information in a file folder. I have been asking to review the list inside a folder that is used by Law Clerks. Each folder would have documents I would then created the list would be the following:
Name of the file – case number
Date modified – mm/dd/year
Type – Microsoft word
File size- KB
Owner – the law clerk that created the document.
I was asked to create a report that would show the above fields for the year 2018. I am using excel 2016 I was looking at using power query, but after view, the data in the power query editor fields I can’t see the file size or the owner fields. Any suggestions. Thanks Brenda. T