- Sub test()
- Dim wordapp As Object
- Dim mydoc As Object
- Set wordapp = CreateObject("word.application")
- Set mydoc = CreateObject("word.document")
- Dim r%, i%
- Dim myapth$, myname$
- Dim brr(1 To 100, 1 To 17)
- Application.ScreenUpdating = False
- mypath = ThisWorkbook.Path & ""
- myname = Dir(mypath & "*.doc")
- Do While myname <> ""
- m = m + 1
- Set mydoc = wordapp.Documents.Open(mypath & myname)
- With mydoc
- With .tables(1)
- brr(m, 1) = Replace(.Cell(1, 2).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 2) = Replace(.Cell(1, 4).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 3) = Replace(.Cell(1, 6).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 4) = Replace(.Cell(2, 2).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 5) = Replace(.Cell(2, 4).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 6) = Replace(.Cell(2, 6).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 7) = Replace(.Cell(3, 2).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 8) = Replace(.Cell(3, 4).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 9) = Replace(.Cell(4, 2).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 10) = Replace(.Cell(4, 4).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 16) = Replace(.Cell(7, 2).Range.Text, Chr(13) & Chr(7), "")
- brr(m, 17) = Replace(.Cell(8, 2).Range.Text, Chr(13) & Chr(7), "")
- ss = Replace(.Cell(5, 2).Range.Text, Chr(13) & Chr(7), "")
- xm = Split(ss, Chr(13))
- For k = 0 To Application.Min(3, UBound(xm))
- brr(m, k + 11) = xm(k)
- Next
- End With
- .Close False
- End With
- myname = Dir
- Loop
- wordapp.Quit
- With Worksheets("sheet1")
- .UsedRange.Offset(2, 0).Clear
- .Columns(9).NumberFormatLocal = "@"
- .Range("a3").Resize(UBound(brr), UBound(brr, 2)) = brr
- End With
- End Sub
复制代码 |