Re: Directory Listing in a Spreadsheet
DH,
I have modified and tested the attached file and it works for directories I do not have access to, though in the 4 or 5 years since I wrote the original, I have never come across this problem strangely enough.
Also realised that I posted a version with locked code so the second post is unlocked for all to see. I am handling the errors by Case as it seemed to be the best solution but I nearly had to learn the code from scratch again as the concept for this spreadsheet came after I got tired of sending dos dir commands to text files but as I had no idea of how to read the details, I borrowed these from a Microsoft example and simply wrote them into recursive calls within a shell routine.
Thanks for the improvement suggestion and happy to hear of any others.
Michael