The code works great, I just don't know how to integrate it in the loop. Currently it loops indefinitely and only appends the first filename in the folder.
Any ideas?
Cheers!
---------------------------------
Function Load_Attendance_Data()
Dim NextFile, ImportFile, FileCriteria, ctr As Variant...