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

🧐 Mandá correos masivos desde Excel con este truco de 30 segundos 📌 ¿Tenés una lista de contactos y querés enviarles mails personalizados sin copiar uno por uno? Este truco te lo resuelve. Pasos clave: 1️⃣ Armá tu tabla con nombre, correo y mensaje personalizado 2️⃣ Abrí el editor de VBA con Alt F11 3️⃣ Pegá este código base: Sub enviarCorreos() Dim OutlookApp As Object Dim OutlookMail As Object Dim i As Integer Set OutlookApp = CreateObject("Outlook.Application") For i = 2 To Cells(Rows.Count