This video illustrates how to write code in Excel VBA that will perform a Loop through all the files in both a folder and any sub folders in a drive location that the user specifies. To do this we need to write 2 subroutines. The first one contains a parameter for the beginning/main path to search in. This first routine also contains the majority of the code that includes loops through the main folder and subfolders of all the files. The second subroutine contains a "call" to the first subroutine and the starting search path is also input.


To get a copy of the workbook used in this video click the link below and look for the file that has the same name as this video title.

[ Ссылка ]

#ExcelVBALoopRecursivelyThroughFolders
#ExcelVBALoopThroughFolderAndSubFolders
#ExcelVBALoopThruFolderAndSubFolders

свернуть