|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub 按钮1_Click()
- Set reg = CreateObject("vbscript.regexp")
- reg.Pattern = "\d+"
- reg.Global = True
- Application.ScreenUpdating = False
- Open ThisWorkbook.Path & "\微信记录.txt" For Input As #1
- s = Replace(StrConv(InputB(LOF(1), 1), vbUnicode), " ", "")
- arr = Split(s, ":")
- Close #1
- str1 = arr(0)
- r = 2
- For j = 1 To UBound(arr)
- Set mh = reg.Execute(arr(j))
- brr = Split(reg.Replace(arr(j), "##"), "##")
- For x = 0 To UBound(brr) - 1
- Cells(r, 6) = brr(x)
- Cells(r, 7) = mh(x)
- Cells(r, 8) = str1
- r = r + 1
- Next x
- str1 = brr(UBound(brr))
- Next j
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|