2,462
社区成员
发帖
与我相关
我的任务
分享
Sub InptDt()
Dim Arr, Ary, k%, i%
Open Application.GetOpenFilename("文本文件,*.txt", , "请选择:", , False) For Input As #1
Arr = Split(StrConv(InputB(LOF(1), 1), vbUnicode), vbCrLf): Reset
ReDim Ary(0 To UBound(Arr), 0 To 6)
For k = 0 To UBound(Arr)
For i = 0 To 6
Ary(k, i) = Split(Arr(k), vbTab)(i)
Next
Next
[A1].Resize(k, 7) = Ary
End Sub
Sub Macro1()
With ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\Temp\1.txt", _
Destination:=Range("A1"))
.Name = "1"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 936
.TextFileStartRow = 1
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = False
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1)
.TextFileTrailingMinusNumbers = True
.Refresh BackgroundQuery:=False
End With
End Sub