Channel: WiseOwlTutorials

Category: Education

Tags: subfree tutorialunzip folderobject libraryunzipwindows shellunzip filesextract filesdecompressearly bindinglate bindingtutorialunpackshell.applicationcopy fileszipmacroshell32.shellzippedonline trainingshell32createobjectfree trainingmicrosoft excelonline tutorialexcelfoldervbashellvisual basic for applicationsnamespacecompressedwise owl

Description: By Andrew Gould Scriptable Shell documentation docs.microsoft.com/en-us/previous-versions/windows/desktop/legacy/bb776890(v=vs.85) 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 the Windows Shell object to unzip a folder with VBA. You'll learn how to reference the Microsoft Shell and Automation Controls library and create a new instance of the Shell class. You'll see how to reference folders using the Namespace method, how to apply the CopyHere method to a destination folder and use the Items method to return the contents of a zipped folder. You'll also see how to achieve the same results using either early-binding or late-binding techniques. Chapters 00:00 The Question 00:29 Creating a New Shell Object 01:53 Referring to Folders using the Namespace Method 04:10 Unzipping Files with the CopyHere Method 05:28 Overwriting Existing Files 07:02 Tidying Up the Code 09:31 Changing from Early Binding to Late Binding 11:22 Taking Care with Data Types 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!