å¯ä»¥å©ç¨VBAï¼å¨å·¥ä½è¡¨æå¼æ¶è§¦åäºä»¶ï¼æå¼csvæ件ï¼ä»£ç 举ä¾å¦ä¸ï¼
Private Sub Workbook_Open()
Dim i&, ar As Variant, wk As Workbook
Dim k As Long, arr()
Set wk = Workbooks.Open("c:\book1.csv")
ar = wk.Sheets("Sheet1").Range("a2:d100") 'è®°ä½å·¥ä½è¡¨ä¸å¾å°çæ°ç»ä¸æ 为1
wk.Close False
For i = 1 To UBound(ar)
If ar(i, 1) = "å¼ ä¸" Then
k = k + 1
ReDim Preserve arr(1 To 4, 1 To k) '注æè¿ä¸ªæ°ç»éè¦è½¬ç½®
arr(1, k) = ar(i, 1)
arr(2, k) = ar(i, 2)
arr(3, k) = ar(i, 3)
arr(4, k) = ar(i, 4)
End If
Next
Range("a5").Resize(k, 4) = Application.Transpose(arr)
End Sub
温馨提示:答案为网友推荐,仅供参考