|
楼主 |
发表于 2014-1-6 13:44
|
显示全部楼层
hwc2ycy 发表于 2014-1-6 13:33
重新生成前,记得关闭打开的WORD文档。
老师你好!
Option Explicit
Sub ToWord()
Dim arr, i As Integer
arr = Range("a1").CurrentRegion.Value
Dim strPath$
strPath = ThisWorkbook.Path & Application.PathSeparator
Dim objWord As Object
Set objWord = CreateObject("word.application")
With objWord
For i = 2 To UBound(arr)
With .documents.Add(Template:=strPath & "模板.doc")
Application.StatusBar = "正在处理 " & arr(i, 2)
.bookmarks("姓名").Range.Text = arr(i, 2)
.bookmarks("性别").Range.Text = arr(i, 8)
.bookmarks("出生年月").Range.Text = arr(i, 9)
.bookmarks("参加工作时间").Range.Text = arr(i, 11)
.bookmarks("政治面貌").Range.Text = arr(i, 6)
.bookmarks("文化程度").Range.Text = arr(i, 18)
.bookmarks("技术等级").Range.Text = arr(i, 15)
.bookmarks("起聘时间").Range.Text = arr(i, 16)
.bookmarks("本人述职").Range.Text = arr(i, 19)
.bookmarks("工作单位").Range.Text = arr(i, 3) & " " & arr(i, 12)
.bookmarks("分管工作").Range.Text = arr(i, 20)
.bookmarks("年度").Range.Text = arr(i, 21)
.bookmarks("年龄").Range.Text = arr(i, 10)
.bookmarks("专业技术类别").Range.Text = arr(i, 14)
.SaveAs strPath & arr(i, 2) & ".doc", FileFormat:=0
.Close True
End With
Next
.Quit
End With
Application.StatusBar = ""
MsgBox "整理完成"
End Sub
红色部分是我加上的,怎么不行呀,提示,没有打到对象
|
|