Sub text()
Dim wj$
wj = Dir(ThisWorkbook.Path & "\*.x*")
Do While wj <> ""
If wj <> ThisWorkbook.Name Then
Workbooks.Open (ThisWorkbook.Path & "\" & wj)
ActiveWorkbook.Sheets(1).Range("b3:b" & ActiveWorkbook.Sheets(1).Cells(Rows.Count, 2).End(3).Row).Copy _
ThisWorkbook.Sheets(1).Rows("2:2").Find(Left(ActiveWorkbook.Name, 4) & "费用").Offset(1, 0)
ActiveWorkbook.Close 1
End If
wj = Dir
Loop
End Sub