|
- Sub Macro1()
- Dim wb As Workbook, mypath$, wj$, arr(1 To 2000, 1 To 2)
- mypath = ThisWorkbook.Path & "\数据"
- wj = Dir(mypath & "*.xls")
- t = [a1]
- Application.ScreenUpdating = False
- Do While wj <> ""
- s = s + 1
- Set wb = GetObject(mypath & wj)
- arr(s, 1) = Split(wb.Name, ".xls")(0)
- Set rng = wb.Sheets(1).Columns(1).Find(t, lookat:=xlWhole)
- If Not rng Is Nothing Then arr(s, 2) = rng.Address(0, 0)
- wb.Close 0
- wj = Dir
- Loop
- With Range("b1").Resize(s, 2)
- .Value = arr
- .Sort [b1], Header:=xlGuess
- End With
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|