Finding Paths >255

[mikesaladin]

Hi,
I downloaded a really helpful file called "Directory Listing.xls" from Michael Hayes
available from:Directory Listing.xls
The original posting was under:Directory Listing in a Spreadsheet

It lists Directories and their contents, filesize etc.
What I need is some code that will look through my hard drive and list
FolderName & Filename as a string where
"the length of the string of the folder name + length of string of filename > 255"
I tried to change the code in the above sheet, but to no avail, I'm a bit of a novice to this. Can anyone help?
I've posted a personal message to Michael, but he hasn't replied.
Any help appreciated - Peter Vowels p.vowels@optusnet.com.au

[Michael Hayes]

Peter,
I only saw the email this morning. I will have a look and see what I can do.
Regards,
Michael

[Michael Hayes]

Peter,
Its all mounting up with Christmas Approaching but here is an updated version which should do what you want. Run the spreadsheet as normal and once the paths and files are displayed, press Ctrl + z and you will get to enter 3 variables.
The first for Path Length
then for File Length and
then for Path + File Length.

In your case, you can fold the first two out of the way by setting them to say 500. The default for each is given as 255.

I chose the approach of filtering and copying existing data as the process of writing the files is undertaken recursively and it got messy to keep backtracking to delete un-needed directories. The output has Path and Filename in seperate cells but you can join these if you need.

Unfortunately, the file doubled in size and so I have had to zip it to get it in here.

Regards,
Michael