MergeWorkbook Method

Applies To

Workbook object.

Description

Merges changes from one workbook into an open workbook.

Syntax

expression.MergeWorkbook(Filename)

expression Required. An expression that returns a Workbook object.

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

Example

This example merges changes from Book1.xls into the active workbook.

ActiveWorkbook.MergeWorkbook "Book1.xls"