|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 yxbaju 于 2018-10-10 21:40 编辑
Sub TextData()
'TEXT在同一文件夹下
'cells.clear
Dim sPath$, sFilename$, sFileFullname$, i&
[a1:g1] = Array("Station", "lontitude", "latitude", "temperatute", "precipitation", "evaparation", "runoff")
sPath = ThisWorkbook.Path & "\"
sFilename = Dir(sPath & "*.txt"): i = 2
Do Until sFilename = ""
sFileFullname = sPath & sFilename
With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;" & sFileFullname, Destination:=Range("A" & i))
.TextFileStartRow = 2
.TextFileConsecutiveDelimiter = True
.TextFileCommaDelimiter = True
.TextFileSpaceDelimiter = True
.TextFileColumnDataTypes = Array(9, 1, 1, 1, 1, 1, 1, 1)
.Refresh False
i = i + .ResultRange.Rows.Count
.Delete
End With
sFilename = Dir
Loop
End Sub
|
|