m-scott-lassiter / vba-directory-manager Goto Github PK

If this is not impossible in VBA method, a feature request: option to only store folders. Because of speed in large folders on network drives (related issue: #2), someone might only want the folders in the directory to show. There is no way currently to write this with the current class module.

Description: When trying to omit the files beginning with "Geo", the OmittedPrefix was set to "geo", but the files did not omit.

Solution: This is because a binary comparison of "Geo" and "geo" is different. Desired functionality is to be indifferent to character case as the file system itself does not account for case when determining the uniqueness of file names.

Description: When parsing a folder with an excessive number of files/folders, Excel appears to freeze.

Desired behavior: Provide feedback to the user that it is in fact still working. Prevent Excel from going not responsive.

Solution: Provide a more specific status bar update when parsing folders, and include DoEvents to prevent lockup.