you could add this line of code just before the "End IF" line
    Sheets("Welcome").Range("C2") = Left(filename, InStr(1, filename, ".xls", vbTextCompare) - 1)