Wise Owl Answers - How do I list all properties of a file using VBA?
By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
/ @wiseowltutorials
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video shows you how to use a Shell object in VBA to loop through the files in a folder and write all the file properrties to a worksheet using the GetDetailsOf method.
https://docs.microsoft.com/en-us/wind...
Chapters
00:00 The Question
01:36 Looping Through Files using a Shell Object
03:22 The GetDetailsOf Method
04:46 Looping Through File Properties
07:45 Writing the Values to a Worksheet
09:20 Listing the Property Names
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!
Watch video Wise Owl Answers - How do I list all properties of a file using VBA? online without registration, duration hours minute second in high quality. This video was added by user WiseOwlTutorials 19 October 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,849 once and liked it 153 people.