I am trying to find a solution either using VBA in excel or another kind of process.
I want to be able to check folders in a directory to see if any files exist in them. If files are found in a folder, I would like to create a txt file with the name of the folder and the name of the files inside that folder. In a separate text a list of empty files.
If I was going down the excel approach, I would like the same as above but I would like to include an hyperlink of the files in the folder so that I can can open them direct.
Thanks for your help