18K views · 74 reactions | ️ Rename hundreds of files in seconds. Turn Excel + VBA into your personal file manager — change extensions, rename batches, and log before-and-after names automatically. Who needs manual renaming when Excel does it faster? ⚙️ #ExcelTips #VBATricks #ExcelAutomation #ExcelShorts | Excel For Freelancers | Facebook

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

📁 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