|
本帖最后由 zjdh 于 2012-8-16 08:19 编辑
- Sub Macro1()
- Dim filearr As Variant, j As Integer
- Dim F As Integer, i As Integer, sh As Worksheet, ARR
- ChDir ThisWorkbook.Path
- filearr = Application.GetOpenFilename(filefilter:="Excel文件,*.xls", MultiSelect:=True)
- If IsArray(filearr) = False Then Exit Sub
- For F = 1 To UBound(filearr)
- With Workbooks.Open(filearr(F))
- Set sh = .Sheets("Sheet1")
- If Not sh Is Nothing Then
- ARR = sh.Range("J18:M23")
- For i = 1 To UBound(ARR)
- j = 0
- If ARR(i, 1) = 6 Then
- For j = 1 To UBound(ARR)
- If ARR(j, 1) = 4 Then
- ARR(j, 2) = ARR(j, 2) + ARR(i, 2)
- ARR(i, 1) = 0
- ARR(i, 2) = 0
- ARR(i, 4) = 0
- Exit For
- End If
- Next
- End If
- If j > UBound(ARR) Then ARR(i, 1) = 4
- Next
- sh.Range("J18:M23") = ARR
- .Close True
- End If
- End With
- Next
- End Sub
复制代码 |
评分
-
查看全部评分
|