试试
Dim mg As New Merger
mg.SourcePath = "d:\快运单.xls"
mg.Format = "excel" '指定格式
mg.SourceTableName = "sheet1$" '指定要合并的表
mg.DataTableName = "快运单" '指定接收数据的表
mg.Merge()
或者
Dim mg As New Merger
mg.SourcePath = "d:\快运单.xlsx"
mg.Format = "excel" '指定格式
mg.SourceTableName = "sheet1$" '指定要合并的表
mg.DataTableName = "快运单" '指定接收数据的表
mg.Merge()
[此贴子已经被作者于2018/1/3 23:06:38编辑过]