好啦,测试成功Sub qiaoqiao2() Dim ph$, fn$, sh As Worksheet
ph = ThisWorkbook.Path & "\"
fn = Dir(ph & "*.xls")
Do While fn <> ""
If fn <> ThisWorkbook.Name Then
With Workbooks.Open(ph & fn)
n = Worksheets.Count
For i = 1 To n
Worksheets(i).Activate
test
Next
.Close True
End With
End If
fn = Dir
Loop
End Sub