可以使用 VBA 代码,实现将多个工作簿合并到一个工作簿中。具体代码如下:
Sub MergeWorkbooks() Dim Fname As Variant Dim Wbk As Workbook Dim Sht As Worksheet Dim Dest As Workbook Dim Last As Long
Fname = Application.GetOpenFilename(filefilter:="Excel Files (*.xls*), *.xls*", _
MultiSelect:=True)