|
发表于 2015-5-22 18:20
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- On Error Resume Next
- Dim i&, j%, k%, zf$, d, d2, d3
- Set wd = CreateObject("Word.Application")
- Set d = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- Set d3 = CreateObject("scripting.dictionary")
- With wd.Documents.Open(ThisWorkbook.Path & "\数据.doc")
- For k = 1 To .Tables.Count
- Cells(k + 2, 1) = k
- For i = 6 To .Tables(k).Rows.Count
- zf = Application.Clean(.Tables(k).Cell(i, 5).Range)
- For j = 7 To 11
- x = Val(Application.Clean(.Tables(k).Cell(i, j).Range))
- If zf = "E" Then d(x) = ""
- If zf = "Seq" Then d2(x) = ""
- If zf = "H" Then d3(x) = ""
- Next
- Next
- Cells(k + 2, 2) = Application.Max(d.keys)
- Cells(k + 2, 3) = Application.Min(d.keys)
- Cells(k + 2, 4) = Application.Max(d2.keys)
- Cells(k + 2, 5) = Application.Min(d2.keys)
- Cells(k + 2, 6) = Application.Max(d3.keys)
- Cells(k + 2, 7) = Application.Min(d3.keys)
- d.RemoveAll: d2.RemoveAll: d3.RemoveAll
- Next
- .Close False
- End With
- wd.Quit
- End Sub
复制代码 |
|