Feb 13 2019 11:22 AM
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
Feb 13 2019 12:08 PM
Size is in the Attribute column if you expand it, owner is not returned
Feb 13 2019 12:31 PM
Feb 13 2019 12:45 PM
I guess that's with VBA coding, or PowerShell script to create .csv file, but I have no such samples