|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 同心/ty 于 2023-3-27 09:38 编辑
求大神帮助:将附图文件doc合并到合同文件doc后面,在excel里实现。论坛一位老师帮我写了一个代码,在此非常感激。此次提出问题是我附图文件是横向排版,而合同是竖向排版。这点代码还要完善。附上代码求完善:1.解决合并后保持2个文件原排版格式(竖横混排)2.解决合并后最后一页空白页删除的问题。
'===================================
Dim oDoc As Object
Dim oRng ' As Range
Set oDoc = MyWord.ActiveDocument
Dim MyRange ' As Range
Dim ObjDoc As Object
Dim myDialog As FileDialog
' On Error Resume Next
Set myDialog = Application.FileDialog(msoFileDialogFilePicker)
With myDialog
.AllowMultiSelect = True
.Filters.Clear
.Filters.Add "所有 WORD 文件", "*.doc*", 1
End With
If myDialog.Show <> -1 Then Exit Sub
For x = 1 To myDialog.SelectedItems.Count
Set ObjDoc = GetObject(myDialog.SelectedItems(x))
Set MyRange = ObjDoc.Range(Start:=0, End:=1)
MyRange.WholeStory
MyRange.Copy
Set oRng = oDoc.Range(Start:=(oDoc.Content.End - 1), End:=(oDoc.Content.End - 1))
oRng.Paste
Next x
'==========================================
End With
MyWord.DOCUMENTS.Save
MyWord.Quit
Set MyWord = Nothing: Set ObjDoc = Nothing
End If
Next
MsgBox "OK 在合同备份文件夹里查看"
End Sub
|
|