|
发表于 2012-3-13 10:01
|
显示全部楼层
本楼为最佳答案
- Sub T()
- Dim Arr, i&, j As Byte, s$, sP$, Wb
- Application.ScreenUpdating = False
- Cells.Clear
- s = ThisWorkbook.Path & "\数据文件"
- sP = Dir(s & "*.xlsx")
- Do While sP <> ""
- Set Wb = GetObject(s & sP)
- With Wb.Worksheets(1)
- Arr = .Range(.Cells(1, 3), .Cells(.Rows.Count, 3).End(3)).Value
- End With
- Wb.Close False
- If IsArray(Arr) Then
- j = j + 1
- Cells(1, j).Resize(UBound(Arr)) = Arr
- Else
- Cells(1, j) = Arr
- End If
- sP = Dir
- Loop
- Application.ScreenUpdating = True
- MsgBox "处理完毕"
- End Sub
复制代码
批量抽取C列数据.rar
(254.8 KB, 下载次数: 30)
|
|