|
Option Explicit
Sub TEST()
Dim ar(), i&, r&, wdApp As Object, wdTable As Object
Dim strFileName$, strPath$, strName$
Application.ScreenUpdating = False
On Error Resume Next
Set wdApp = GetObject(, "Word.Application")
If Err <> 0 Then
Set wdApp = CreateObject("Word.Application")
End If
ReDim ar(1 To 10 ^ 3, 1)
strPath = ThisWorkbook.Path & "\"
strFileName = Dir(strPath & "*.doc*")
Do Until strFileName = ""
strName = Left(strFileName, InStrRev(strFileName, ".") - 1)
With wdApp.documents.Open(strPath & strFileName)
For Each wdTable In .Tables
If InStr(wdTable.Range.Cells(1).Range.Text, "档案编号") Then
r = r + 1
ar(r, 0) = strName
ar(r, 1) = Left(wdTable.Range.Cells(1).Range.Text, Len(wdTable.Range.Cells(1).Range.Text) - 2)
End If
Next
.Close False
End With
strFileName = Dir
Loop
[A1].CurrentRegion.Clear
If r Then [A1].Resize(r, 2) = ar
If Err <> 0 Then wdApp.Quit
Set wdApp = Nothing
Application.ScreenUpdating = True
Beep
End Sub
|
评分
-
1
查看全部评分
-
|