Loop through files in a folder using VBA?
Here's my interpretation as a Function Instead:
'#######################################################################'# LoopThroughFiles'# Function to Loop through files in current directory and return filenames'# Usage: LoopThroughFiles ActiveWorkbook.Path, "txt" 'inputDirectoryToScanForFile'# https://stackoverflow.com/questions/10380312/loop-through-files-in-a-folder-using-vba'#######################################################################Function LoopThroughFiles(inputDirectoryToScanForFile, filenameCriteria) As String Dim StrFile As String 'Debug.Print "in LoopThroughFiles. inputDirectoryToScanForFile: ", inputDirectoryToScanForFile StrFile = Dir(inputDirectoryToScanForFile & "\*" & filenameCriteria) Do While Len(StrFile) > 0 Debug.Print StrFile StrFile = Dir LoopEnd Function