把鼠标移到sheet标签位置,右键--查看代码--把下面的代码复制进弹出窗口--点击运行--选择要合并的工作簿--打开。
Sub 合并()
Dim FilesToOpen As Variant, x As Integer, xname As String
On Error Resume Next
Application.ScreenUpdating = False
FilesToOpen = Application.GetOpenFilename _
(FileFilter:="Microsoft Excel Files, *.xls*", _
MultiSelect:=True, Title:="选取要合并的文件")
If TypeName(FilesToOpen) = "Boolean" Then
MsgBox "没有文件被选中!"
Exit Sub
End If
x = 1
While x <= UBound(FilesToOpen)
Workbooks.Open Filename:=FilesToOpen(x)
xname = Left(ActiveWorkbook.Name, InStrRev(ActiveWorkbook.Name, ".") - 1)
Sheets().Move after:=ThisWorkbook.Sheets _
(ThisWorkbook.Sheets.Count)
Sheets(Sheets.Count).Name = xname
x = x + 1
Wend
Application.ScreenUpdating = True
End Sub
追问WPS的话怎么操作呢?