Workbook.MergeWorkbook (Excel)

Merges changes from one workbook into an open workbook.

MergeWorkbook (Filename)

Filename: The file name of the workbook that contains the changes to be merged into the open workbook.

ActiveWorkbook.MergeWorkbook "Book1.xls"