Manage
Learn to apply best practices and optimize your operations.
File/Folder Recursion
Download: IT Certifications 101
Inside this exclusive essential guide, our independent experts break down which IT certifications are worth your time and effort, and how to get started obtaining them to further your career— including specific certifications that any cloud or desktop pro should seriously consider.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
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
This was last published in November 2000
Start the conversation
0 comments