list subfolders and files of main folder with details

Hi buerere and welcome to ExcelForum,

When you post code, you need 'code tags'. See the forum rules for instructions:
http://www.excelforum.com/forum-rule...rum-rules.html

Please add code tags or you will get no other responses to your post.

See the following thread. The file associated with post #2 will probably lead you in the right direction.
http://www.excelforum.com/excel-prog...h-results.html

Good luck.

Lewis

Details:
Name
Size
Last Date Modified
number of files in each subfolder

** A vbs file that returns the list of subfolders and files contained in a main file, with their details **

 Set ObjSubFolders = ObjFolder.SubFolders 
 For Each ObjFolder In ObjSubFolders 

 ObjOutFile.WriteLine("Folder," & ObjFolder.Name & "," & ObjFolder.Path & "," & ObjFolder.Files.Count)

will add the number of files in the folder to the end of the line

thank you so much ragulduy!

Out of interest..

Here's one that will do everything except your last bit (counting files in subfolders)...

It would be interesting to see if the last requirement could be added to it..

Private Sub CommandButton1_Click()
    Dim Z
    Z = Split(Replace(CreateObject("wscript.shell").exec("cmd /c forfiles /P C:\Test /S /M  *.*  /c ""cmd /c echo  @file!@FSIZE!@fdate""").stdout.readall, Chr(34), ""), vbCrLf)
    Range("A1").Resize(UBound(Z)).Value = Application.Transpose(Split(Join(Z, vbLf), vbLf))
    Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row).TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, Other:=True, OtherChar:="!"
    Range("A1").Resize(1, 3).Value = Array("FileName", "Size", "Date Modified")
End Sub

Hi

i need a similar code for the following work

everyday a new sub folder is created in my parent folder D:\XYZ ...

1) Insert the name of sub folder in Col A (Cell 1)
2)Count the number of files in Subfolder [ Col B Cell 2)

Next day shift this row to down and do the same

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

---------------------

Please post your question in a new thread. You can put a link to this thread if you like.

Lewis