Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Folder Path + file Name Length and Insert into Spreadsheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Folder Path + file Name Length and Insert into Spreadsheet
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 -- TommySzalapsk ----------------------------------------------------------------------- TommySzalapski's Profile: http://www.excelforum.com/member.php...fo&userid=2556 View this thread: http://www.excelforum.com/showthread.php?threadid=39024 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to extract only file name from folder path string in Excel? | Excel Worksheet Functions | |||
Launching an XL file gives errors for each folder in path, then opens | Excel Discussion (Misc queries) | |||
UNC Path length problem opening a file in excel 2002 or 2003 | Excel Discussion (Misc queries) | |||
Path\File name length problem Excel Crash on save as | Excel Discussion (Misc queries) | |||
find if there is a particular folder in a path | Excel Programming |