Collection: Files
- Updated2024-09-12
- 1 minute(s) read
(Collections | FileSystemObject) > Collection: Files
Collection: Files
Collection of all File objects. You can use the Files collection to count files or to access individual files.
The following example generates a collection of all files in the given folder:
Function CreateFileList(sFolder) Dim fso, oMyFolder, oMyFile, oMyFiles, sOutput Set fso = CreateObject("Scripting.FileSystemObject") Set oMyFolder = fso.GetFolder(sFolder) Set oMyFiles = oMyFolder.Files For Each oMyFile in oMyFiles sOutput = sOutput & oMyFile.Path & VBCrLf Next CreateFileList = sOutput End Function