- Sub test()
- Dim r%, i%, m%
- Dim brr(1 To 1000, 1 To 22)
- Dim mypath$, myname$
- Dim wordapp As Object
- Dim mypdoc As Object
- Dim mytables As Object
- Set wordapp = CreateObject("word.application")
- mypath = ThisWorkbook.Path & ""
- myname = Dir(mypath & "*.docx")
- Do While myname <> ""
- Set mydoc = wordapp.documents.Open(Filename:=mypath & myname)
- With mydoc
- With .tables(1)
- m = m + 1
- brr(m, 1) = m
- brr(m, 2) = Replace(.cell(1, 2).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 3) = Replace(.cell(2, 2).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 4) = Replace(.cell(2, 4).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 5) = Replace(.cell(3, 4).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 6) = Replace(.cell(4, 2).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 7) = Replace(.cell(2, 6).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 8) = ""
- brr(m, 9) = Replace(.cell(6, 2).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 10) = Replace(.cell(3, 6).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 11) = Replace(.cell(5, 6).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 12) = Replace(.cell(4, 6).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 13) = Replace(.cell(7, 2).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 14) = ""
- brr(m, 15) = ""
- brr(m, 16) = ""
- brr(m, 17) = ""
- brr(m, 18) = ""
- brr(m, 19) = Replace(.cell(8, 4).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 20) = Replace(.cell(6, 2).Range.Text, Chr(13) & Chr(7), "")
- End With
- End With
- mydoc.Close False
- myname = Dir
- Loop
- wordapp.Quit
- With Worksheets("汇总")
- .UsedRange.Offset(2, 0).ClearContents
- .Range("a3").Resize(m, UBound(brr, 2)) = brr
- End With
- End Sub
复制代码 |