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

16K views · 145 reactions |  Instantly list all files in a folder—right inside Excel. Use a simple VBA macro to loop through any directory and drop file names straight into your sheet. Perfect for photo logs, audits, or file tracking. Level up your Excel game  Join the community: https://www.excelforfreelancers.com/op/be-part-of-our-excel-community #excelvba #exceltips #automation #filetracking #excelforfreelancers List files in folders | Excel For Freelancers | Facebook