|
dtxczjzmp 发表于 2012-1-26 15:45 ![](static/image/common/back.gif)
感谢zhaogang1960老师的关心和帮助!但还有一个小问题那就是brr(m, 3) = "局" & j - 3这一句我不怎么理解 ... - Sub Macro1()
- Dim MyPath$, MyName$, arr, brr(1 To 60000, 1 To 4), i&, j&, m&
- MyPath = ThisWorkbook.Path & ""
- MyName = Dir(MyPath & "*.xls")
- Application.ScreenUpdating = False
- Do While MyName <> ""
- If MyName <> ThisWorkbook.Name Then
- With GetObject(MyPath & MyName)
- arr = .Sheets(1).[a1].CurrentRegion
- .Close False
- End With
- For j = 4 To UBound(arr, 2)
- If Len(arr(6, j)) = 0 Then arr(6, j) = arr(6, j - 1)
- Next
- For i = 8 To UBound(arr)
- If Len(arr(i, 1)) > 8 Then
- For j = 4 To UBound(arr, 2)
- If Len(arr(i, j)) Then
- m = m + 1
- brr(m, 1) = arr(i, 1)
- brr(m, 2) = arr(i, 2)
- brr(m, 3) = arr(6, j)
- brr(m, 4) = arr(i, j)
- Exit For
- End If
- Next
- End If
- Next
- End If
- MyName = Dir
- Loop
- ActiveSheet.UsedRange.Offset(4).ClearContents
- [a5].Resize(m, 4) = brr
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|