|
楼主 |
发表于 2021-8-11 09:01
|
显示全部楼层
本帖最后由 jone_huang 于 2021-8-11 11:29 编辑
大神, 能依Tspliu最新在你的基础上修改的再加另外三个数据么, 实在是对VB不懂, 一个字都改不了..
直接抄了楼上大神的,另三个数据你也参照弄一下就可以了,思路就是这个思路。
Sub byWanao()
Dim Filename$, myDir$, myText, mArr() As String, jsNum&
myDir = Dir(ThisWorkbook.Path & "\*.txt")
Debug.Print myDir
Do While myDir <> ""
Filename = ThisWorkbook.Path & "\" & myDir
Open Filename For Input As #1
s = StrConv(InputB(LOF(1), 1), vbUnicode)
jsNum = Cells(Rows.Count, 1).End(xlUp).Row + 1
mArr = Split(s, "FF:FF:FF:FF:FF:FF,", , 0)
For i = 1 To UBound(mArr)
str1 = Split(mArr(i), ",", , 0)(0)
Cells(jsNum + i, 1) = "'" + str1
Next
Close #1
myDir = Dir
Loop
End Sub |
|