|
楼主 |
发表于 2013-5-25 10:52
|
显示全部楼层
那么的帅 发表于 2013-5-25 10:03
因为 数据文件夹只有5个文件,所以代码为 5,如果有49个文件,把5修改成49,其他代码不要改
代码中有注释
...
老师您好,谢谢您帮助。里面一共有 四个地方有 5 都要改吗?
For i = 1 To 5 '49 因为 数据文件夹只有5个文件,所以代码为 5,如果有49个文件,把5修改成49,其他代码不要改
myFile = Format(i, "00") & ".xlsx"
Set AK = XLapp.Workbooks.Open(myPath & myFile)
XLapp.Visible = False
With AK
For j = 2 To 49
With .Sheets(j)
lr = .Range("A" & .Rows.Count).End(xlUp).Row
arr1 = .Range("A1:E" & lr)
For p = 1 To lr Step 3
If arr1(p, 1) = TJ1 And arr1(p + 1, 1) = TJ2 And Round(arr1(p, 5) - arr1(p + 1, 5), 0) = TJ3 Then
m1 = m1 + 1
ReDim Preserve Arr11(1 To 7, 1 To m1 * 3)
For Y = 1 To 5
Arr11(Y, m1 * 3 - 2) = arr1(p, Y)
Arr11(Y, m1 * 3 - 1) = arr1(p + 1, Y) |
|