Its very odd. I have a whole subdirectory called 'dq' that vFile isn't not looping through. I debugged the For Next statement and it shows that the directory is completely skipped within colFiles. Spaces aren't the issue since there are other folders and files with spaces that colFiles successfully collects.
All the files within the problematic directory are uppercase, but it wouldn't make a difference since Search isn't case sensitive. This is evident after debugging, since the function is properly collecting all subdirectories with the criteria of 'dq' regardless of case; all with the exception of the missing directory, hence leaving no files to Search since they have not been added to the collection.
The wildcard formatting doesn't seem to be a problem either, since there are folders both 'dq' and 'DQ' that are added to the collection. I've even tried changing the name of the subdirectory. In addition, the subdirectory before and after are being added to the collection. Its as if the subdirectory might as well not exist. I'm stumped.
Bookmarks