Loop Through All Files in a Folder Using VBA/Macros in Excel

[@jeffmartinez262]

Thanks, this was exactly what I needed to know. The "Dir" function was completely new to me. I watched this video and was able to build my code with no problems at all. Thanks again.

[@TeachExcel]

You're very welcome Jeff! I'm glad I could help!

[@j.dasilva4567]

Seen many vba tutorials, u got the right way to do this. Great work. Thank u.

[@shivangimittal7482]

Good Tutorial! Thank you for precise and simple explanations. Found it very useful

[@scooble]

Cool....I didn't realise Geoff Goldbloom was such an Excel expert!

[@teoxengineer]

Very good explanation, thank you very much. I offen use FileSystemObject method instead of Dir one because it provides more flexiblity for me. Also, when I use FSO, I can learn more things for example windows file directory info like hard disc size, name or file paths including extentions, modification dates, establishing dates etc. Can you make an handy video about File System Object usage?

[@VinodKRamachandra]

I really liked the flow.

[@deninsrmic4165]

Great tutorial, brilliantly explained going step by step through. This part of the code is something I was looking for to append workbooks (containing one sheets each) on top of each other something similar to power query. Thank you for the video. 👍🍀

[@ryanzortman9165]

Like the videos. How about looping through another workbook to find a value. Kind of like a vlookup or xlookup with a press of a button.

[@shakhobiddinnakiev6767]

thank you bro, great tutorial!!!

[@nadermounir8228]

Thank u very much for your hard work. A quick question: do you have any tutorial on class modules in VBA ?

[@SITIOOTITS]

Do you have a code or a tutorial video on how to generate a worksheet file whether its excel or csv format. Using vba template.

[@naiduvikas202]

Great video and amazing stuff

[@carolmarie4488]

@TeachExcel - I had a macros that was working perfectly, then updated to Windows 11 and it all went crazy. After I was finally able to unblock the security issues, it started to work but it's only capturing the data in one file inside the directory/folder where it's supposed to pull all the data from (there are 9 total files there). What could the problem be?

[@CarolSelles-s3k]

@TeachExcel - we had a macro that was working perfectly. Then updated to Windows 11 and it didn't even open. We did the unblocking etc., and now it will only read one file inside the folder where all them are. What could be wrong with it?

[@ruthlammers6441]

Very very helpful!!!!!!

[@francocortesi9718]

Excuse me, but what about differencies between EXCEL for WINDOWS against for MAC in managing Files-Folders propriety? have you got some video on this topics?

[@anoshjustin9592]

Can we get the list of word document also?

[@designexperience]

How do I do this for OneDrive online storage

[@Tat-cx1lr]

Bonjour Merci pour votre partage Ma macro ne fonctionne pas au niveau de copy:= Pourriez-vous svp m’aider Fred

[@sunelidberg9503]

Good video