|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Option Explicit
Sub test()
Dim strResult$(), ar, j&, r&, n As Byte, strFileName$, strPath$
ReDim strResult(1 To 10 ^ 5, 0)
strPath = ThisWorkbook.Path & "\"
strFileName = Dir(strPath & "*.txt")
Do Until strFileName = ""
n = FreeFile
Open strPath & strFileName For Input As #n
ar = Split(StrConv(InputB(LOF(n), #n), vbUnicode), vbCrLf)
Close #n
For j = 0 To UBound(ar)
r = r + 1
strResult(r, 0) = ar(j)
Next j
strFileName = Dir
Loop
Columns("A").Clear
[A1].Resize(r) = strResult
Beep
End Sub
|
评分
-
3
查看全部评分
-
|