|
- Private Sub CommandButton1_Click()
- Dim i As Integer
- Dim j As Integer
- Dim x As Integer
- Dim arr()
- Dim lCount As Long
- On Error GoTo ErrorHandler
- lCount = Me.ListView1.ListItems.Count
- If lCount = 0 Then
- MsgBox "列表中无数据可写入工作表"
- Exit Sub
- End If
- ReDim arr(0 To lCount, 1 To 7)
- For i = 1 To 7
- arr(0, i) = Sheet4.Cells(1, i)
- Next
- With Me.ListView1
- For i = 1 To lCount
- With .ListItems(i)
- arr(i, 1) = .Text
- For j = 2 To 7
- arr(i, j) = .SubItems(j - 1)
- Next j
- End With
- Next i
- End With
- With Sheet3
- Application.ScreenUpdating = False
- i = .Cells(Rows.Count, "b").End(xlUp).Row
- If i > 13 Then
- .Range("b13:h" & i).ClearContents
- End If
- .Range("b13").Resize(lCount + 1, 7).Value = arr
- Application.ScreenUpdating = True
- End With
- MsgBox "导出完成"
- Exit Sub
- ErrorHandler:
- MsgBox Err.Number & vbCrLf & _
- Err.Description
- End Sub
复制代码 |
|