|
Option Explicit
Dim A(1 To 10 ^ 4, 1 To 3), i
'入口
Sub wd2sht()
Dim p, f
'1)清除
Application.ScreenUpdating = False
Sheets(1).Select
[a4:k65536] = ""
'2)收集
p = ThisWorkbook.Path & "\"
f = Dir(p & "*.doc*")
Do While f <> ""
Call Wd2Arr(GetObject(p & f))
f = Dir()
Loop
'3)输出
If i Then [f4].Resize(i, UBound(A, 2)) = A
End Sub
'文档到数组
Sub Wd2Arr(wd)
i = i + 1
A(i, 1) = zh(wd.tables(1).Cell(3, 1).Range.Text)
A(i, 3) = zh(wd.tables(1).Cell(6, 3).Range.Text)
wd.Close 0
End Sub
'去除特殊字符
Function zh(x)
zh = Left(x, Len(x) - 2)
End Function
1.rar
(39.39 KB, 下载次数: 123)
|
|