|
Sub 图片排版()
Application.ScreenUpdating = False
Dim Word对象, 当前路径, 导出文件名, 导出路径文件名, i, j
Dim arr()
Set Word对象 = CreateObject("Word.Application")
路径 = ThisWorkbook.Path & "\"
当前路径 = ThisWorkbook.Path & "\"
导出文件名 = Format(Date, "yyyymmdd") & "排版文件.docx"
导出路径文件名 = 当前路径 & "\" & 导出文件名
ReDim arr(1 To 500, 1 To 1)
f = Dir(路径 & "*.webp")
Do While f <> ""
m = m + 1
arr(m, 1) = 路径 & f
f = Dir
Loop
FileCopy 当前路径 & "模板.docx", 导出路径文件名
With Word对象
.Documents.Open 导出路径文件名
.Visible = True
.ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument '设置位置在正文
.Selection.WholeStory '全选
.Selection.Copy '复制
If m > 1 Then
For i = 2 To m '复制页
.Selection.EndKey 'Unit:=wdStory '光标置于文件尾
.Selection.InsertBreak Type:=7 'wdPageBreak '分页
.Selection.PasteAndFormat (wdPasteDefault) '粘贴
Next i
End If
For i = 1 To m '复制页
tp = arr(i, 1)
.ActiveDocument.Tables(i).Cell(1, 1).Range.InlineShapes.AddPicture Filename:=tp, LinkToFile:=False, SaveWithDocument:=True '直接插入
.ActiveDocument.InlineShapes(i).Height = 550 '调整图片高度
Next i
.ActiveDocument.Close
End With
Word对象.Quit
Application.ScreenUpdating = True
MsgBox "ok!"
End Sub
|
评分
-
1
查看全部评分
-
|