Check out our other answers here [ Ссылка ]
Download files here [ Ссылка ]
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link [ Ссылка ] to make a donation. Thanks for watching!
Learn how to write a recursive subroutine in Excel VBA to loop through all the folders and subfolders from any starting folder. You'll use the Microsoft Scripting Runtime library to work with FileSystemObjects and loop through the Files and Subfolders collections of a Folder object. As a bonus you'll learn how to insert pictures into an Excel worksheet and resize and position these into a neat arrangement.
Chapters
00:00 The Question
01:56 Referencing the Scripting Runtime Library
03:33 Looping Through Files in a Folder
05:08 Calling a Subroutine with Parameters
07:05 Looping Through Subfolders
08:07 Recursively Calling a Procedure
09:21 Viewing the Call Stack
15:35 Inserting and Resizing a Picture
21:08 Setting the Left Position of a Shape
24:14 Adding a New Worksheet
25:09 Finding the Bottom Right Cell of a Shape
27:28 Finding the Top Position of a Cell
29:37 Checking that a Folder Contains Files
30:48 Testing the System
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
Ещё видео!