Loop through files in a folder using VBA?

by

Dir takes wild cards so you could make a big difference adding the filter for test up front and avoiding testing each file

Sub LoopThroughFiles()
    Dim StrFile As String
    StrFile = Dir("c:\testfolder\*test*")
    Do While Len(StrFile) > 0
        Debug.Print StrFile
        StrFile = Dir
    Loop
End Sub

More Related Contents:

  1. using for loop for vba
  2. Simple VBA code to open cells one after the other
  3. Copy data from cell in selected row
  4. How do I base64 encode a string efficiently using Excel VBA?
  5. Programmatic Access To Visual Basic Project Is Not Trusted
  6. Can I make this macro more efficient or faster?
  7. Conditional Formatting using Excel VBA code
  8. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  9. How to get the background color from a Conditional Formatting in Excel using VBA
  10. VBA Excel Populate ListBox with multiple columns
  11. VBA Integer Overflow at 70,000
  12. How to count up text of a different font colour in excel
  13. How to “flatten” or “collapse” a 2D Excel table into 1D?
  14. VBA Macro to compare all cells of two Excel files
  15. VBA – How the colon `:` works in VBA code with condition
  16. How to create a separate CSV file from VBA?
  17. VBA: How to change the value of another cell via a function?
  18. Running VBA from a HYPERLINK()
  19. Sending formatted Lotus Notes rich text email from Excel VBA
  20. How can I generate GUIDs in Excel?
  21. Range.Find not making a difference between January and November (February and December) in VBA Excel
  22. Remove Duplicates from range of cells in excel vba
  23. Excel Select vs Activate
  24. How can an Excel Add-In respond to events in any worksheet?
  25. Iterating through all the cells in Excel VBA or VSTO 2005
  26. How can I display my windows user name in excel spread sheet using macros? [closed]
  27. How does Excel’s worksheet password protection work
  28. Hiding active workbook programmatically in Excel
  29. Excel VBA Project has generated multiple Workbook objects
  30. How to find a value in an excel column by vba code Cells.Find

Leave a Comment