按钮公式:
Dim mg As New Mergermg.SourcePath = ProjectPath & "供方报价表.xls"mg.Format = "excel" '指定格式mg.SourceTableName = "原材料报价表$" '指定要合并的表mg.DataTableName = "原材料报价表" '指定接收数据的表mg.Filter = "[材料名称] <> ''" '指定合并条件mg.Merge() '开始合并