Finding specific excel files
I have the following to find files in a folder with .xls extension.
Dim MyPath As String
FilesInPath = Dir(MyPath & "*.xls")
How would tweak this to find excel files that start with "1_"?
Any help would be much appreciated!
Kevin
|