Thank you all. I modified and it brings in a filename, but it lists the LAST file name it imports for ALL the records, instead of the each file name that it pulls in. (pulling in data from several different files).
Dim ImportDir As String, ImportFile As String
ImportDir =...