本帖最后由 雨吧 于 2016-12-2 09:46 编辑
- Sub YuBa()
- Dim ar, arr, brr(1 To 100, 1 To 9), i&, j&, k%, n&
- On Error GoTo Exit0
- ar = Sheet1.[a1:a3]
- ph = ThisWorkbook.Path & "\A"
- Application.ScreenUpdating = False
- For j = 1 To 49
- Set tb = Workbooks.Open(ph & j & "\1.xlsx")
- For i = 1 To UBound(ar)
- n = n + 1
- For k = 1 To 9
- brr(n, k) = tb.Sheets(1).Cells(ar(i, 1), k)
- Next
- Next
- tb.Close False
- n = n + 1
- Next
- Exit0:
- Application.ScreenUpdating = True
- Sheet2.UsedRange = ""
- Sheet2.[a1].Resize(n, 9) = brr
- MsgBox "提取结束"
- End Sub
复制代码
提取组数据附件.rar
(217.51 KB, 下载次数: 11)
|