|
- Sub test1()
- Dim strFileName$
- Dim fn, a$, b
- Dim arr()
- Dim i As Long
- fn = FreeFile
- ReDim arr(1 To 2, 1 To 1)
- strFileName = ThisWorkbook.Path & "\试验.txt"
- Open strFileName For Input As #fn
- Do While Not EOF(1)
- i = i + 1
- ReDim Preserve arr(1 To 2, 1 To i)
- Line Input #1, a
- b = Split(a, Space(12))
- arr(1, i) = b(0)
- arr(2, i) = b(1)
- Loop
- Close #fn
- If i Then
- b = WorksheetFunction.Transpose(arr)
- End If
- End Sub
复制代码 |
|