|
- Sub Macro1()
- Dim wb As Workbook, mypath$, wj$, arr(1 To 31, 1 To 2)
- mypath = ThisWorkbook.Path & ""
- wj = Dir(mypath & "*.xls")
- Application.ScreenUpdating = False
- Do While wj <> ""
- If wj <> ThisWorkbook.Name Then
- Set wb = GetObject(mypath & wj)
- s = s + 1
- arr(s, 1) = wb.Sheets(1).[b2]
- arr(s, 2) = Val(Split(wb.Sheets(1).[a11], "当日消耗水:")(1))
- wb.Close 0
- End If
- wj = Dir
- Loop
- Range("a2:b200").ClearContents
- Range("a2").Resize(s, 2) = arr
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|