TeachExcel

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

Excel Project

The downloadable files for this project are available once you purchase it.

Questions? Contact Us

Price: $9.95 (usd)

Project Video > Loop Through a Folder Using VBA/Macros Video

How to loop through an entire directory or folder using VBA & Macros for Excel.

This allows you to go through every file in a directory and to do something with it, including open it, check it, delete it, update it, or whatever else you need to do with it.

I also show you how to limit the files that you go though:

  • Limit file types that you loop through.
  • Limit file names that you loop through.
  • Use wildcard characters to go through files with certain names and types.

This tutorial serves as the basis for many more complex things that I show you how to do in my Full Vba Course.


Project Video

Project Files