|
发表于 2016-1-20 21:21
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- On Error Resume Next
- Set wd = CreateObject("Word.Application")
- s = 2
- With wd.Documents.Open(ThisWorkbook.Path & "\源数据.doc")
- For i = 1 To .Paragraphs.Count
- zf = .Paragraphs(i).Range
- If zf Like "*基站:*" Then
- s = s + 1
- Cells(s, 2) = Split(zf, ":")(0)
- zf2 = .Paragraphs(i + 1).Range
- Cells(s, 3) = Mid(Split(zf2, "E:")(0), 4)
- Cells(s, 4) = Replace(Split(zf2, "E:")(1), ")", "")
- End If
- Next
- .Close False
- End With
- End Sub
复制代码 |
|