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:SHORTSShorts") For Each oFile In oFolder.Files Cells(i 1, 1) = oFile.Name i = i 1 Next oFile End Sub | Excel By Vikal

Ever wished you could list files in a folder with Excel VBA in just 1 minute? 🕐📁 In this quick tutorial, I'll show you the magic of Excel VBA. You'll master this task in no time. Efficiency at its best! Ready to supercharge your Excel skills? Let's do this! 💼🚀 Watch more Excel Tutorials Here: https://www.youtube.com/@ExcelForFreelancers CHECK MY PRODUCTS AND COURSES HERE: https://www.excelforfreelancers.com/ #ExcelForFreelancers #ExcelMagic #ExcelVBA #ExcelTutorials #AutomationMastery | Exce