How To Merge Excel Files MsgBox "Files Merged Successfully!" End Sub wbSource.Close False Filename = Dir Loop how to merge excel files