2,462
社区成员
发帖
与我相关
我的任务
分享
Sub test()
Dim wb As Workbook
Set wb = Application.Workbooks.Open("d:\wdxx\hi555.xlsx")
Dim sht As Worksheet
For Each sht In wb.Worksheets
If InStr(sht.Name, "aa") > 0 Then
sht.Cells.Copy
Dim sht2 As Worksheet
Set sht2 = ThisWorkbook.Sheets.Add(After:=ThisWorkbook.Sheets(ThisWorkbook.Sheets.Count))
sht2.Name = sht.Name
sht2.Cells.PasteSpecial
Application.CutCopyMode = False
End If
Next
wb.Close
End Sub