Manage
Learn to apply best practices and optimize your operations.
File/Folder Recursion
Scripting Runtime" refernce on your machine you will be able to use the
following code to recurse through the directory structure on a machine to
identify and/or modify files and folders. I wrote this with the intention of
finding all *.ft folders on a server and logging their size. I was then able
to determine how much space was being utilized by full text indexes in Notes.
Dim FSO As Variant
Dim Files As Variant
Dim SubFolders As Variant
Dim initFolder As Variant
Dim TextFile As Variant
Sub Initialize
Set FSO = CreateObject("Scripting.FileSystemObject")
Set initFolder = FSO.GetFolder("C:\")
Set SubFolders = initFolder.Subfolders
Set Files = initFolder.Files
Set TextFile = FSO.CreateTextFile("C:\RecurseTest.txt")'This will create a
text file on your C: drive
If SubFolders.Count > 0 Then
Forall x In SubFolders
TextFile.WriteLine(x.Path)
Recurse(x)
End Forall
End If
TextFile.Close
End Sub
Function Recurse(CurFolder As Variant)
Dim Sub_RFolders As Variant
Dim RFolders As Variant
Set RFolders = CurFolder.SubFolders
Forall y In RFolders
Set Sub_RFolders = y.SubFolders
TextFile.WriteLine(y.Path)
If Sub_RFolders.Count > 0 Then
Recurse(y)
End If
End Forall
End Function
