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