Thread: Find Folder Path + file Name Length and Insert into Spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
TommySzalapski[_10_] TommySzalapski[_10_] is offline
external usenet poster
  
Posts: 1
Default 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 With QuoteReply With Quote