I am using Office 2003. I am trying to run two filesearches in the same sub. The first run runs no problem and I get the multiple files that I require.
When the second one runs, it always finds 0 files no matter how many files are actually in the directory in which it is searching.
Any suggestions on how to run two separate file searches?
Code for the second file search:
When the second one runs, it always finds 0 files no matter how many files are actually in the directory in which it is searching.
Any suggestions on how to run two separate file searches?
Code for the second file search:
Code:
With fs
.NewSearch
.SearchSubFolders = False
.FileName = "*.pdf"
.LookIn = "C:\Temp"
MsgBox (.FoundFiles.Count)
End With