Listing files and folders using FSO

[Un-Do Re-Do]

I want to list files and folders with the macro below.
The rules are as follows.
1. For any folder containing the name "SPECIAL", only the folder should be listed. No files, just the folder name.
2. For any other folder, only the files are listed within.


I am having issues with the first criteria, in that I get multiple listing of the same folder.
The feature which adds rows needs to be kept as it will allow me to place new data in between existing data.

Is there a change to make it work ... without changing the structure of the code.
Also there is another unusual feature, files seem to get listed alphabetically whereas folders are listed in reverse order.

Please Login or Register  to view this content.

[Un-Do Re-Do]

Will this be possible?

[Leith Ross]

Hello Un-Do Re-Do,

See if this amended version of your workbook is correct.

[Un-Do Re-Do]

Hi. Thanks for looking into.
Unfortunately it has the same issue.
If you try with multiple folders with the "SPECIAL" tag, you'll get multiple listings.
Inserting data between existing is also important.

[Un-Do Re-Do]

This seems to have worked.

Please Login or Register  to view this content.