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!
Смотрите видео Wise Owl Answers - How do I list all properties of a file using VBA? онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь WiseOwlTutorials 19 Октябрь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,849 раз и оно понравилось 153 людям.