|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub tiqu()
-
- Dim dpath, Filename As String
- Dim wdapp As Word.Application
- Dim wddocument As Word.Document
- Dim arr(1 To 20)
- dpath = ThisWorkbook.Path
- Set wdapp = New Word.Application
- Application.ScreenUpdating = False
- Filename = Dir(dpath & "\*.doc")
- On Error Resume Next
- Do While Filename <> ""
- Set wddocument = wdapp.Documents.Open(dpath & "" & Filename)
- With wddocument
- arr(1) = .Tables(1).Cell(1, 2).Range.Text
- arr(2) = .Tables(1).Cell(1, 4).Range.Text
- arr(3) = .Tables(1).Cell(2, 4).Range.Text
- arr(4) = .Tables(1).Cell(3, 2).Range.Text
-
- arr(5) = .Tables(2).Cell(5, 2).Range.Text
- arr(6) = .Tables(2).Cell(6, 2).Range.Text
- arr(7) = .Tables(2).Cell(7, 2).Range.Text
- arr(8) = .Tables(2).Cell(2, 2).Range.Text
-
- arr(9) = .Tables(2).Cell(3, 2).Range.Text
- arr(10) = .Tables(4).Cell(5, 2).Range.Text
-
- arr(11) = .Tables(5).Cell(1, 1).Range.Text
- arr(12) = .Tables(6).Cell(1, 1).Range.Text
-
- x = .Tables(4).Rows.Count '不规格表格找处目标入组人数
- For i = 10 To x
- str1 = Mid(.Tables(4).Cell(i, 1).Range.Text, 1, 6)
- If str1 = "目标入组人数" Then
- arr(15) = .Tables(4).Cell(i, 2).Range.Text
- arr(16) = .Tables(4).Cell(i + 1, 2).Range.Text
- i = x
- End If
- Next i
- arr(13) = .Tables(7).Cell(12, 2).Range.Text '第一个机构
- arr(14) = .Tables(7).Cell(12, 3).Range.Text
-
- arr(17) = .Tables(7).Cell(13, 2).Range.Text '第二个机构
- arr(18) = .Tables(7).Cell(14, 3).Range.Text
- For i = 1 To 20
- arr(i) = Replace(arr(i), vbCr & "", "")
- Next
-
- End With
- With Sheet1
- r = .[a65536].End(xlUp).Row + 1
- .Range("A" & r).Resize(1, 16) = arr
- If arr(17) <> "" Then
- arr(13) = arr(17)
- arr(14) = arr(18)
- r = r + 1
- .Range("A" & r).Resize(1, 16) = arr
- End If
- End With
- wddocument.Close
- Filename = Dir()
- Loop
- Set wddocument = Nothing
- wdapp.Quit
- Set wdapp = Nothing
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|