Prev: Calculating column A * column B = Results in another column
Next: Alert Message After Somthing Changed
From: H�ctor Miguel on 30 Mar 2010 19:33
hi, minyeh !

> Have a similar question, how can i get a file listing from a specific folder including its subfolders?
> for example, my parent folder is "Customer List" under that Folder, i have several sub folders named like "A-F", "G-L", "M-R", "S-Z",
> and under each folders is the sales reports [.xls] or [.xlsx] for each customers, named by their customer ID and the date of last modified.
> can i get a master listing of these files (excluding the folders) including the filetype?
> (either in one column or two column is fine) ...

as Esra comments, Chip Pearson as in his web-site articles related to this listing folders-files (i.e.)
http://www.cpearson.com/excel/FolderTree.aspx

and downloadable examples as:
http://www.cpearson.com/Zips/DirTreeXLS.zip
http://www.cpearson.com/Zips/DirTreeSetup;.zip

hth,
hector.


First  |  Prev  | 
Pages: 1 2
Prev: Calculating column A * column B = Results in another column
Next: Alert Message After Somthing Changed