|
Sub kk()
Dim fso As Object, txt As Object
Dim strPath As String, f As Object, arr_data(1 To 65536, 1 To 1)
Set fso = CreateObject("Scripting.FileSystemObject")
strPath = ThisWorkbook.Path & "\Data"
For Each f In fso.GetFolder(strPath).Files
ex_name = fso.GetExtensionName(f)
n = 0
Erase arr_data
If ex_name = "txt" Then
sht_name = Split(fso.GetBaseName(f), "_")(4)
Set txt = fso.OpenTextFile(f, ForReading)
Do While txt.AtEndOfStream = False
n = n + 1
arr_data(n, 1) = txt.ReadLine
Loop
On Error Resume Next
Set sht = Worksheets(sht_name)
sht.Cells.Clear
sht.Range("a1").Resize(n, 1) = arr_data
If Err.Number <> 0 Then
Set sht = Worksheets.Add(, Worksheets(Worksheets.Count))
sht.Name = sht_name
sht.Range("a1").Resize(n, 1) = arr_data
Err.Clear
End If
End If
Next
Set fos = Nothing
End Sub |
评分
-
查看全部评分
|