excel vba case sensitivity in a recursive function problem

[terriertrip]

I'm using some code example by Albert Kallall and Browne that uses a recursive function to build a collection of files based on a string search where strFileSpec is set to a wildcard file. srtTemp is the temporary directory being added to the collection if strFileSpec is True. As it is, strFileSpec is case sensitive at the code level, but the files vary in case sensitivity - some are all upper, some all lower, and even some are Proper. Is there a way to set an argument to find a search strFileSpec, regardless of case at the code level?

Please Login or Register  to view this content.

[BrianM45]

Hi terriertrip

Can we have the global code or the file that contains it?

[terriertrip]

I've attached a sample file with code explanation.

[BrianM45]

Hi terriertrip,

For me the problem is not in the recursive function of the path, but in GetFiles procedure

Test

Please Login or Register  to view this content.

The line below

Please Login or Register  to view this content.

[terriertrip]

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.

[BrianM45]

Hi

Where is the folder called 'dq' ?
Not in this screen capture

[terriertrip]

Apologies for the confusion. The folder 'dq files' was originally called 'dq'. I ran the routine with both file name versions. Either way, that folder is being skipped. Everything in Permian and San Juan folders is being searched.

[BrianM45]

Hi,

So sorry for you, but at home the search works perfectly with the "dq files" folder

What criteria do you enter in the 2 dialog boxes ?

Is folder ownership not over hidden ?

[terriertrip]

Yes very frustrating for me since it makes no sense. There is no difference in ownership or hidden files/folders.
The criteria I input into the dialog boxes are: 1) dq 2) Benzene
Below are all the files not being collected. The image on the right are the files within 'raw text data'

[terriertrip]

I ran another test and used 'DQ' instead of 'dq' in the folder criteria for strFileSpec and it worked!!! It looped through all directories that had the string 'dq' and 'DQ' and listed all files that were named 'dq' and 'DQ'. I sure would like to know why it worked for uppercase but not lowercase.