|
本帖最后由 oubaiyas122 于 2014-6-5 21:23 编辑
论坛老师:
您们好!
后学需要将在附件中的文本文档提取相应的内容到EXCEL里,效果同附件中EXCEL的形式。请各位看看怎么写代码为好,谢谢!
- Sub Macro1()
- On Error Resume Next
- Dim arr(), i&, zf$
- Open ThisWorkbook.Path & "\附件.txt" For Input As #1
- w = Split(StrConv(InputB(LOF(1), #1), vbUnicode), "--- END")
- Close #1
- ReDim arr(1 To UBound(w), 1 To 2)
- For i = 0 To UBound(w) - 1
- zf = Split(Split(w(i), "IY=")(1), ",")(0)
- arr(i + 1, 1) = Mid(zf, 2, Len(zf) - 2)
- arr(i + 1, 2) = Split(Split(w(i), " 产品类型 = ")(1), vbCrLf)(0)
- Next
- Range("a2").Resize(UBound(arr), 2) = arr
- End Sub
复制代码
|
|