订单登记表中的代码!供参考!
Sub test()
Dim i&, r&, fName$, wb As Workbook, arr, brr(1 To 50, 1 To 30)
fName = ThisWorkbook.Path & "\采购单.xlsx"
Set wb = GetObject(fName)
arr = wb.Sheets(1).[a1].CurrentRegion
wb.Close 0
For i = 6 To 45
If Len(arr(i, 3)) Then
r = r + 1
brr(r, 2) = arr(3, 2)
brr(r, 3) = arr(4, 2)
brr(r, 4) = arr(i, 3)
brr(r, 6) = arr(46, 12)
brr(r, 7) = arr(2, 10)
brr(r, 8) = arr(3, 4)
brr(r, 9) = arr(49, 2)
brr(r, 11) = arr(2, 7)
brr(r, 12) = arr(3, 7)
brr(r, 13) = arr(2, 2)
Else
Exit For
End If
Next
If r Then
With Sheet2
.[a1].CurrentRegion.Offset(1) = ""
.[a2].Resize(r, 30) = brr
End With
End If
End Sub
|