Channel: WiseOwlTutorials

Category: Education

Tags: extended attributefoldersfree tutorialonline trainingfree trainingmicrosoft excelonline tutorialexcelfilefoldervbaloop through filesshellvisual basic for applicationspropertyfilestutorialattributewise owl

Description: 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: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link 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. docs.microsoft.com/en-us/windows/win32/shell/folder-getdetailsof 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 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!