Question : iterate all file in a folder vba
Answered by : alex-lanaro-14ziv22qcwmq
Dim StrFile As String
StrFile = Dir("c:\testfolder\*test*")
Do While Len(StrFile) > 0
Debug.Print StrFile
StrFile = Dir
Loop
Source : https://stackoverflow.com/questions/10380312/loop-through-files-in-a-folder-using-vba | Last Update : Tue, 02 Feb 21