Sub MultiCsvImport()
Dim dateien, i, lastrow
lastrow = 1
dateien = Application.GetOpenFilename _
(
"txt-Dateien (*.txt), *.txt"
, MultiSelect:=True)
If IsArray(dateien) Then
For i = 1 To UBound(dateien)
Workbooks.Open dateien(i), local:=True
With ThisWorkbook.Sheets(1)
ActiveSheet.UsedRange.
Copy
Destination:=.Range(
"A"
& lastrow)
.Rows(lastrow &
":"
& lastrow + 1).
Delete
shift:=xlShiftUp
lastrow = .UsedRange.Rows.
Count
+ 1
End
With
ActiveWorkbook.Close False
Next i
End
If
End
Sub