Option Explicit
'References
'1. Microsoft Scripting Runtime
Global gFso As Scripting.FileSystemObject
Sub Main()
Set gFso = New Scripting.FileSystemObject
TraversePreorder "C:\KS Work\Temp"
End Sub
Sub TraversePreorder(ByVal sPath As String)
Dim oFolder As Scripting.Folder, vMember As Variant
If gFso.FolderExists(sPath) Then
Debug.Print sPath 'Process folder
Set oFolder = gFso.GetFolder(sPath)
For Each vMember In oFolder.Files
TraversePreorder vMember
Next vMember
For Each vMember In oFolder.SubFolders
TraversePreorder vMember
Next vMember
Else
Debug.Print sPath 'Process file
End If
End Sub
Nuts and bolts about programming applications, databases and spreadsheets. Note: Comments are moderated to filter comment spam. Mobile version
2015-11-10
Recursive preorder traversal of a folder tree in VBA
To process files in a folder tree using Excel, I implemented a recursive preorder traversal of a tree in VBA below. I haven't had to do this earlier because I usually use Gnu "find . -exec" to process files in folders.
Labels:
MS-Excel,
VB/VBA/VBScript
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment