|
发表于 2012-4-26 21:26
|
显示全部楼层
本楼为最佳答案
- Sub tqwb()
- Dim a() As String, b() As String, i&, rq, r1
- Sheet1.Activate
- Open "C:\Users\Administrator\Desktop\TTTT.txt" For Input As #1
- a = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf)
- [b2].Resize(UBound(a) + 1, 1) = a
- Close #1
- End Sub
复制代码 |
评分
-
查看全部评分
|