如何将每一个TXT文本数据,复制到一个sheet表格中,19个TXT文本,就对应有19个sheet子表对应的数据 (TXT文本中数据可能是全数字,或全文字及其它字符)
- Sub tt()
- Dim fso, fp, arr, sh As Worksheet, f, strf, col%, str1$, Firstv$, n&, k%, u%
- Set fso = CreateObject("scripting.filesystemobject")
- Set fp = fso.getfolder(ThisWorkbook.Path)
- Application.DisplayAlerts = False
- Application.ScreenUpdating = False
- For Each sh In Sheets
- If sh.Name <> "Sheet1" Then sh.Delete
- Next
- Application.DisplayAlerts = True
- For Each f In fp.Files
- If fso.getextensionname(f) = "txt" Then
- Set strf = fso.opentextfile(f)
- str1 = strf.ReadAll '¶áè¡μ½str1
- ' n = strf.Line 'óD¶àéù¸öÄúèY
- Firstv = Split(fso.getfilename(f), ".")(0) 'txtÎļtÃû3Æ
- strf.Close
- arr = Split(str1, vbCrLf)
- Sheets.Add After:=Sheets(Sheets.Count)
- With ActiveSheet
- .Name = Firstv
- .Range("a1").Resize(UBound(arr)) = Application.Transpose(arr)
- .Columns("A:A").EntireColumn.AutoFit
- End With
- End If
- Next
- Set fso = Nothing
- Application.ScreenUpdating = True
- End Sub
复制代码略微该下,是否满足要求
|