Copying data from multiple word docs into one excel sheet
Solution 1:
Your comment indicates the file name includes the date you want. You are accessing the filename in the variable myFile. Why not chop that apart to get the date, and insert it somewhere you want? You could make it the first or last cell in the destination table, for example.
Example added:
Try adding this new row to your script.
Next c
'new
xl.activeworkbook.activesheet.Cells(xlRow, xlCol + 1) = myFile
xlRow = xlRow + 1