|
现使用字典等功能(Application.Max(d.keys))查得到了最大值77,但是现在我想取得左端的数值3。我思路是通过字典功能(Application.Max(d.keys))得到最大值77的位置,然后利用某个函数把77所在的地址(位置)表达出来,由于77与3所处的位置有一定的联系,最后将77与3写入EXCEL中。
本帖最后由 dsmch 于 2015-5-24 08:34 编辑
- Sub Macro1()
- On Error Resume Next
- Dim i&, j%, k%, zf$, d
- Set wd = CreateObject("Word.Application")
- Set d = CreateObject("scripting.dictionary")
- s = 2
- With wd.Documents.Open(ThisWorkbook.Path & "\位置.doc")
- For i = 1 To .Tables(1).Rows.Count
- zf = Application.Clean(.Tables(1).Cell(i, 5).Range)
- For j = 2 To 3
- x = Val(Application.Clean(.Tables(1).Cell(i, j).Range))
- d(x) = i
- Next
- Next
- Cells(s, 2) = Application.Max(d.keys)
- n = d(Application.Max(d.keys))
- If n Mod 2 = 0 Then n = n - 1
- Cells(s, 3) = Application.Clean(.Tables(1).Cell(n, 1).Range)
- d.RemoveAll
- .Close False
- End With
- wd.Quit
- End Sub
复制代码
|
|