+ Reply to Thread
Results 1 to 10 of 10

excel vba case sensitivity in a recursive function problem

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Colorado, US
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    518

    Re: excel vba case sensitivity in a recursive function problem

    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.
    Last edited by terriertrip; 10-20-2020 at 11:24 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Case sensitivity with IF statement
    By AceForSale in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-18-2018, 10:31 AM
  2. SQL LIKE case sensitivity issue
    By keyston in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2011, 09:16 AM
  3. write name checking function where case sensitivity does not matter
    By netdude_18 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-23-2008, 01:39 PM
  4. multiple if's and case sensitivity
    By xcelnoob in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2007, 09:54 PM
  5. Using EXACT function without case-sensitivity?
    By Kayote in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-23-2007, 09:53 AM
  6. [SOLVED] VLookup & Case Sensitivity
    By KHogwood-Thompson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2006, 04:35 AM
  7. Case Sensitivity problem with data validation
    By Upya in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2005, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1