Sub test()
Dim p As String, f As String
Dim A(1 To 1000, 1 To 6) As String
Dim i As Integer
Application.ScreenUpdating = False
p = ThisWorkbook.Path & "\"
f = Dir(p & "*.doc")
Do While f <> ""
With GetObject(p & f).Tables(1)
i = i + 1
A(i, 1) = delChar(.cell(2, 2))
A(i, 2) = delChar(.cell(3, 2))
A(i, 3) = delChar(.cell(8, 2))
A(i, 4) = delChar(.cell(8, 4))
A(i, 5) = delChar(.cell(12, 4))
A(i, 6) = getIP(.cell(17, 2))
End With
f = Dir()
Loop
Range("a1").CurrentRegion.Offset(1, 0).ClearContents
[A2].Resize(i, UBound(A, 2)) = A
End Sub
'删除多余的字符
Function delChar(x As String) As String
delChar = Left(x, Len(x) - 1)
End Function
'获取IP和掩码
Function getIP(str As String) As String
With CreateObject("vbscript.regexp")
.Global = True
.Pattern = "(\d+\.){3}\d+"
If .Execute(str).Count Then getIP = .Execute(str)(0) & "/" & .Execute(str)(1)
End With
End Function
2.rar
(36.96 KB, 下载次数: 26)