count subfolders
 

Hi,
The properties of a windows folder gives you file size on disk, file count,
and folder count.
I need a vba to extract that info.
Any ideas???

peter
(nested folders and files included)

count subfolders
 

Sub GetFolderInfo()

strFolder = "C:\temp"

Set fso = CreateObject _
("Scripting.FileSystemObject")
Set folder = _
fso.GetFolder(strFolder)


FolderSize = folder.Size
Files = folder.Files.Count
Subfolders = folder.Subfolders.Count
Size = folder.Size
End Sub


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149288