Sub LoopThroughFiles2()
Dim StrFile As String
Path = ActiveWorkbook.Path
StrFile = Dir(Path & "\")
Do While Len(StrFile) > 0
Debug.Print StrFile
StrFile = Dir
Loop
End Sub
Dim StrFile As String
Path = ActiveWorkbook.Path
StrFile = Dir(Path & "\")
Do While Len(StrFile) > 0
Debug.Print StrFile
StrFile = Dir
Loop
End Sub
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.