Excel VBA to Count Files in a Folder

10K views · 157 reactions | Make file list from folder  #vikominstitute #excel #vba CODE Sub LoopThroughFiles() Dim oFSO As Object Dim oFolder As Object Dim oFile As Object Dim i As Integer Set oFSO = CreateObject("Scripting.FileSystemObject") Set oFolder = oFSO.GetFolder("E:\SHORTS\Shorts") For Each oFile In oFolder.Files Cells(i + 1, 1) = oFile.Name i = i + 1 Next oFile End Sub | Excel By Vikal | Facebook