A Handy tip

  • Create two Constants: FirstFileDate and LastFileDate as Longs
  • Paste the Date parts of the first file name and the last file name into two Excel Cells
  • Format those cell as Number with no decimal places.
  • Give the two constants those numerical values


Now you can iterate thru all files with
For d = FirstFileDate to LastfileDate
    Filename = "SENSOR REPORT " & Format(d, "dd-mmm-yy")
    '
    '
    '
Next d