|
楼主 |
发表于 2024-4-9 18:14
|
显示全部楼层
本帖最后由 同心/ty 于 2024-4-10 09:11 编辑
Sub test()
Application.ScreenUpdating = False
Arr = Worksheets("sheet1").UsedRange
Set doc = CreateObject("word.application")
'Set fso = CreateObject("Scripting.FileSystemObject")
Set obmapp = CreateObject("Shell.Application").BrowseForFolder(0, "请选择文件目录:", 0, 0)
If Not obmapp Is Nothing Then
fp = obmapp.Self.Path & ""
Else
Exit Sub
End If
f = Dir(fp & "\*.doc")
Do While f <> ""
rr = Left(f, 18)
For i = 1 To UBound(Arr)
If Arr(i, 2) = rr Then
s1 = Arr(i, 4)
s2 = Arr(i, 5)
Exit For
End If
Next
Set WD = doc.Documents.Open(fp & "\" & f)
'doc.Visible = True
With WD.Tables(1)
.Cell(11, 2) = s1
.Cell(14, 2) = .Cell(14, 2) & s2
End With
f = Dir
WD.Close True
Loop
Application.ScreenUpdating = True
MsgBox "填充完成"
End Sub
|
|