Sub aa()
On Error Resume Next
Dim rep As New RegExp, mac, sr As String, x As Integer, fname As String, filename
Dim xls As Object
Set xls = ThisWorkbook.Sheets("Sheet1")
fname = Dir(ThisWorkbook.Path & "\*.doc")
Do
x = x + 1
fname = Dir
Loop Until fname = ""
For i = 1 To x
filename = ThisWorkbook.Path & "\" & i & ".doc"
Set doc = GetObject(filename)
xls.Cells(i + 1, 1) = Left(doc.Tables(1).cell(2, 2), Len(doc.Tables(1).cell(2, 2)) - 1)
xls.Cells(i + 1, 2) = Left(doc.Tables(1).cell(3, 2), Len(doc.Tables(1).cell(3, 2)) - 1)
xls.Cells(i + 1, 3) = Left(doc.Tables(1).cell(8, 2), Len(doc.Tables(1).cell(8, 2)) - 1)
xls.Cells(i + 1, 4) = Left(doc.Tables(1).cell(8, 4), Len(doc.Tables(1).cell(8, 4)) - 1)
xls.Cells(i + 1, 5) = Left(doc.Tables(1).cell(12, 4), Len(doc.Tables(1).cell(12, 4)) - 1)
sr = doc.Tables(1).cell(17, 2)
With rep
.Global = True
.MultiLine = True
.Pattern = "(\d+\.){3}\d+"
Set mac = .Execute(sr)
End With
xls.Cells(i + 1, 6) = mac(0) & "/" & mac(1)
Next
Set rep = Nothing
End Sub