Sub TEST()
myStr = Application.GetOpenFilename(("Excel Files (*.xls*), *.xls*"), , "选择数据文件")
Set Bk = Workbooks.Open(myStr)
For Each SH In Bk.Sheets
If SH.Name = "明细" Then
T = True
SH.Range("A3:J" & SH.Range("A65536").End(3).Row).Copy
ThisWorkbook.Sheets("明细").Range("A65536").End(3)(2).PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End If
Next
Bk.Close False
If T = "" Then MsgBox "该工作簿中没有〖明细〗工作表!": Exit Sub
MsgBox "数据已导入!"
End Sub