|
本帖最后由 lijian8003 于 2014-2-28 14:09 编辑
下列代码将z1.txt数据导入excel,但是z1.txt的数据01导入excel 后,却变为1,单元格事先设置为文本格式,也是1
如何使txt文本数据01导入excel后依然是01?
Sub 导入01()
Sheets("01").Select
Application.DisplayAlerts = False '关闭报警
Dim s() As String '定义字串数组
Open ThisWorkbook.Path & "\z1.txt" For Input As #1 '打开文本文件
s = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf) 'InputB(LOF(1), 1)读入内存,StrConv 编码转换;Split()分割成行
Close #1 '关闭文件
[c1].Resize(UBound(s) + 1, 1) = WorksheetFunction.Transpose(s) '将整个数组置于AA列
[c1:c1].TextToColumns [c1] '按TAB分列(分列符默认就是tab)
Application.DisplayAlerts = True '打开报警
End Sub
Sub 导入01()
Sheets("01").Select
Application.DisplayAlerts = False '关闭报警
Dim S() As String '定义字串数组
Open ThisWorkbook.Path & "\z1.txt" For Input As #1 '打开文本文件
S = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf) 'InputB(LOF(1), 1)读入内存,StrConv 编码转换;Split()分割成行
Close #1 '关闭文件
[c1].Resize(UBound(S) + 1, 1) = WorksheetFunction.Transpose(S) '将整个数组置于AA列
[c1:c1].TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
:=Array(Array(1, 2), Array(2, 2), Array(3, 2)), TrailingMinusNumbers:=True '按TAB分列(分列符默认就是tab)
Application.DisplayAlerts = True '打开报警
End Sub
|
|