|
以“现场调测记录表(光功率记录表-白塔小区1#8幢3号)1”工作簿作为模板,根据MA5612表格里的每行名字复制word文档:- Sub Macro2()
- Dim p$, f$, s$, arr, i&
- s = "白塔小区1#8幢3号"
- arr = [a1].CurrentRegion
- p = ThisWorkbook.Path & ""
- Application.ScreenUpdating = False
- With CreateObject("Word.Application")
- .Visible = False
- For i = 1 To UBound(arr)
- f = p & "现场调测记录表(" & arr(i, 1) & ").doc"
- FileCopy p & "现场调测记录表(光功率记录表-白塔小区1#8幢3号)1.doc", f
- .Documents.Open f
- .Selection.HomeKey Unit:=6
- If .Selection.Find.Execute(s) Then '查找到指定字符串
- .Selection.Font.Color = wdColorAutomatic '字符为自动颜色
- .Selection.Text = arr(i, 1) '替换字符串
- End If
- .Documents.Close True
- Next
- .Quit
- End With
- Application.ScreenUpdating = True
- MsgBox "ok"
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|