MS Office Tips: Excel VBA: The Dir Function
The most common use of the Dir function is to loop through all the files in a folder to perform an action on each one. Other common uses include checking if a file or a directory exists, or to look for a specific file such as the latest one....