Sub test() ‘操作多工作簿多工作表 DIR+OPEN 方法
Application.DisplayAlerts = False
Mypath = ThisWorkbook.Path
Myfile = Dir(Mypath & "\*.xls*")
Do Until Myfile = ""
If Myfile <> ThisWorkbook.Name Then
Set WK = Workbooks.Open(Mypath & "\" & Myfile)
For Each SH In WK.Sheets ‘多工作表操作
ARR=SH.Range("A1").CurrentRegion
'................
Next
WK.Close False
End If
Myfile = Dir
Loop
Application.DisplayAlerts = True
End Sub