|
上传代码,- Sub 提取数据()
- With Application
- .ScreenUpdating = False: .DisplayAlerts = False: .EnableEvents = False: .AutoFormatAsYouTypeReplaceHyperlinks = False: .AskToUpdateLinks = False
- End With
- Dim mFull$, wb As Workbook, arr, AR(), BR(), CR(), DR(), m&, i&
- mFull = ThisWorkbook.Path & "\WH1810014-C01-00.xls"
- Set wb = CreateObject(mFull) ' 打开
- With wb.Sheets("Sheet1")
- ' .Cells.SpecialCells(xlCellTypeConstants, 16).ClearContents
- .Cells.SpecialCells(xlCellTypeFormulas, 16).ClearContents
- arr = .UsedRange.Value
- End With
- wb.Close False
- ReDim AR(1 To UBound(arr), 1 To 1)
- ReDim BR(1 To UBound(arr), 1 To 2)
- ReDim CR(1 To UBound(arr), 1 To 1)
- ReDim DR(1 To UBound(arr), 1 To 1)
- For i = 3 To UBound(arr)
- If arr(i, 5) <> "" Then
- m = m + 1
- AR(m, 1) = arr(i, 3)
- BR(m, 1) = arr(i, 5)
- BR(m, 2) = arr(i, 6)
- CR(m, 1) = arr(i, 10)
- DR(m, 1) = arr(i, 13)
- End If
- Next
- With Worksheets("B号对应表")
- .Range("A2").Resize(m, 1) = AR
- .Range("C2").Resize(m, 2) = BR
- .Range("H2").Resize(m, 1) = CR
- .Range("K2").Resize(m, 1) = DR
- End With
- With Application
- .ScreenUpdating = True: .DisplayAlerts = True: .EnableEvents = True: .AutoFormatAsYouTypeReplaceHyperlinks = True: .AskToUpdateLinks = True
- End With
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|