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 - [ Ссылка ]

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 - [ Ссылка ]

Find more great free tutorials at;
[ Ссылка ]

Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]

свернуть