Loop Through Subfolders of a Folder using Excel VBA

This video tutorial will walk you through a macro to loop through the subfolders of a folder searching for a specific file. Each part of the Excel VBA code is explained in the video, and you can get it from this link - http://goo.gl/Mf8cPq This macro uses File System Object, also known as FSO, to access and run routines on the files and folders of a directory. FSO makes working with files and folders in Excel VBA easy. This macro searches for a specific file. When found the file is opened and a range is copied from it into the current file. This part of the macro can easily be changed to perform a different task. If you seriously want to master Excel VBA, check out our online course - https://goo.gl/oTPQZj Find more great free tutorials at; http://www.computergaga.com Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1