This time-saving macro will let you select a folder path and loop through each of the Excel files matching the file filter (default setting *.xl*) in that folder.
There are several ways to create a list of files in a folder and its sub-directories. The most commonly used object based model by Excel VBA developers to access the computer's file system is the FileSystemObject (FSO), which is available inside the Microsoft Scripting Runtime library.
Comments