Find Folder Path + file Name Length and Insert into Spreadsheet

S

Steve Roberts

Our company has found a fatal flaw in a program that is caused by too long
of a path. The company wants us to go through our folders and shorten the
paths to less than 200 characters including the file name. Any suggestions
on how I can have excel scan all folders + subfolders + files for ones that
exceed 200 characters and insert the offendign paths into a spreadsheet.
This would save us from counting our 2500 root folders + subfolders.

Thanks

Steve
 
T

TommySzalapski

Open up the MS-DOS command prompt and type this code

C: 'or whatever your drive letter is for the folders
cd\ 'this gets you to the root
dir/s/b > files.txt 'this will put your whole file list in a the fil
(will take a while)

Next open the file (Drive:\files.txt) in Excel and use =len(A1) i
column B and sort it by that column, blah blah. I think you can get i
from here
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Long Path Tool - Fix Path Too Long Forever 1
Maximum length of File plus path name for excel workbooks 0
http://LongPathTool.com Long Path Tool recognizes the processes orrunning programs which have loc 0
http://LongPathTool.com Long Path Tool recognizes the processes orrunning programs which have locke 0
File Path Name Length 9
http://LongPathTool.com - Copy, Unlock and Delete Path Too Long files 0
Mass File Column Insert and Name 1
file name length restrictions 2

Top