Document Tree Generator - Misses Empty Files

Hi,

First of all, much credit to Robert Mundigl @ www.clearlyandsimply.com
I've been using the attached spreadsheet of his to generate a list of all documents & the files they are in - which allows me to use my basic VBA skills to make it automatically organise into a document tree.

However, the code does not generate an item for folders on the system which contain nothing - it skips them instead.

I'm currently having to manually check the system, then insert a new row on the spreadsheet and put in a value [EMPTY].

I need to see which folders on the document tree are empty - so this is essential.


So the values it would output would look like:

C:\stuff\morestuff\document.exe
C:\stuff\morestuff\document2.exe
C:\stuff\otherstuff\[EMPTY]
C:\stuff\yetmorestuff\document3.exe

or something similar.


This is beyond my basic VBA skills - any help would be appreciated!

Thanks for the response Leith!

I gave your spreadsheet a go, it's great that it finds empty folders too.
Unfortunately I had problems straight from the start - As the attached (sanitized) image shows.

Bearing in mind the folder I chose was empty apart from folder containing more folders of files
• Files were being generated with no folder path
• File types was being put into the 'File Size' column sometimes. Sometimes not.
• File size results were being inputted into the file Type column,

Mainly the first point - I couldn't understand where the results were coming from.

Hi Leith,

I recently upgraded to Excel 2016 MSO (16.0.8201.2213) 32-bit on Windows 7 Enterprise
Part of a Microsoft Office 365 ProPlus Subscription.
Version 1705 (Build 8201.2213 Click-to-Run)

I don't mind if a ZIP folders subfolders aren't listed - they could be just be listed at a top level, like I believe the 1st spreadsheet might have done.

I might have a mess with part of your sub 'ListAllFiles'
See if I can integrate the "'Check if Folder has no files." section into my original spreadsheets code...