|
若是固定的一个地址,可以先选择地址记录后,每次到此地址(目录)中提取。
当然也可以直接修改宏达到。
Sub 导入txt()
Application.ScreenUpdating = False
Ph = "F:\常用工具\hh2" & "\"
DirName = Dir(Ph & "*.txt")
While DirName <> ""
Open Ph & DirName For Input As #1
SJ = StrConv(InputB(LOF(1), 1), vbUnicode)
Close #1
With Sheets("提取数据")
W = .Range("A65536").End(3).Row + 1
.Cells(W, 1) = W - 1
.Cells(W, 2) = Split(SJ, ";")(0)
.Cells(W, 3) = Split(SJ, ";")(3)
.Cells(W, 4) = Split(SJ, ";")(4)
.Cells(W, 5) = Split(SJ, ";")(5)
.Cells(W, 6) = Split(SJ, ";")(7)
.Cells(W, 7) = Mid(SJ, InStr(SJ, ";" & Split(SJ, ";")(7) & ";") + Len(Split(SJ, ";")(7)) + 2, 200)
End With
Kill (Ph & DirName)
DirName = Dir
Wend
Application.ScreenUpdating = True
Application.OnTime Now + TimeValue("00:00:30"), "导入txt" '30秒运行一次
End Sub
|
评分
-
查看全部评分
|