VBA导入CSV文件

VBA导入CSV文件

Sub importCSV()
Dim wb0, wb1 As Workbook
Dim ws0 As Worksheet
On Error GoTo exit1
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Set wb0 = ThisWorkbook
wb0.Activate
Set ws0 = ActiveSheet
With Application.FileDialog(msoFileDialogFilePicker)
.Filters.Clear
.Filters.Add "csv", "*.csv"
.AllowMultiSelect = True
.InitialFileName = ThisWorkbook.path
.Title = "Please select the csv file you wanna import"
.Show

For Each path In .SelectedItems
    ws0.Cells.Delete
    If BookOpen(path) Then
        Set wb1 = Workbooks(Split(path, "\")(UBound(Split(path, "\"))))
    Else
        Set wb1 = Workbooks.Open(path)
    End If
   
    For Each ws In wb1.Sheets
        If ws.Cells(1, 1) = "" Then
            ws.Rows("1:" & ws.Cells(65535, 1).End(xlUp).row).Copy
        Else
            ws.UsedRange.Copy
        End If
        ws0.Activate
        If ws0.UsedRange.Rows.count > 1 Then
        Else
            ws0.Cells(ws0.UsedRange.Rows.count, 1).Resize(ws.UsedRange.Rows.count, ws.UsedRange.Columns.count).Select
        End If
        ws0.Paste
    Next
    wb1.Close False
Next
ws0.Cells.WrapText = False

End With
Application.DisplayAlerts = True
Application.ScreenUpdating = True
Exit Sub

exit1:
Application.DisplayAlerts = True
Application.ScreenUpdating = True
MsgBox "Error!"
End Sub

Function BookOpen(ByVal path As String) As Boolean
    Dim wb As Workbook
    BookOpen = False
    For Each wb In Application.Workbooks
        If wb.FullName = path Then
            BookOpen = True
            Exit For
        End If
    Next
End Function