用宏插入对应图片生成Word

Yuesc 2015-05-22 02:45:56
由于工作关系需要把对应的图片插入到word,最近工作要求变了,原来编写的代码已经不能满足工作的需求,我想修改但是下面的代码对于我这种菜鸟来说还是不怎么懂原来代码可以一次插入3个图,但是现在要求要插入4个图,但是我明白要从哪里入手,求大神帮忙!!


代码如下:


Option Explicit


Public Sub InsertPOD()
Dim objFS As Object
Dim podLocation
Dim podFileCollection
Dim podImg

Dim ScreenCaptureLocation
Dim ScreenCaptureCollection
Dim ScreenCapture

Dim myArr(1000) As String
Dim myArrCon() As String
Dim i As Integer
Dim Amount As Integer

Dim con As String
Dim PicPath As String
Dim PodPath As String
Dim SavePath As String
Dim WaybillPath As String

Dim addPath As String

con = ActiveDocument.Content.Text
myArrCon = VBA.Split(con, Chr(13))
PicPath = myArrCon(0) & "\"
PodPath = myArrCon(2) & "\"
SavePath = myArrCon(1)

addPath = myArrCon(3) & "\"



Set objFS = CreateObject("Scripting.FileSystemObject")
Set podLocation = objFS.getfolder(myArrCon(0))
Set podFileCollection = podLocation.Files

On Error Resume Next

i = 1
For Each podImg In podFileCollection

myArr(i) = Left(podImg.Name, 16)

i = i + 1
Next

Amount = i - 1
i = 1

If myArrCon(3) = "" Then
Do While i <= Amount
Documents.Add Template:="Normal", NewTemplate:=False, DocumentType:=0
Selection.InlineShapes.AddPicture FileName:=PicPath & myArr(i) & ".tif", LinkToFile:=False, SaveWithDocument:=True

Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.TypeParagraph

Selection.InlineShapes.AddPicture FileName:=PodPath & myArr(i) & ".tif", LinkToFile:=False, SaveWithDocument:=True

ChangeFileOpenDirectory SavePath

ActiveDocument.SaveAs FileName:=myArr(i) & ".doc"

ActiveDocument.Close
i = i + 1
Loop
Else
Do While i <= Amount
Documents.Add Template:="Normal", NewTemplate:=False, DocumentType:=0
Selection.InlineShapes.AddPicture FileName:=PicPath & myArr(i) & ".tif", LinkToFile:=False, SaveWithDocument:=True

Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.TypeParagraph
Selection.InlineShapes.AddPicture FileName:=PodPath & myArr(i) & ".tif", LinkToFile:=False, SaveWithDocument:=True

Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.TypeParagraph
Selection.InlineShapes.AddPicture FileName:=addPath & myArr(i) & ".tif", LinkToFile:=False, SaveWithDocument:=True


ChangeFileOpenDirectory SavePath

ActiveDocument.SaveAs FileName:=myArr(i) & ".doc"

ActiveDocument.Close
i = i + 1
Loop
End If



End Sub
...全文
828 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

5,139

社区成员

发帖
与我相关
我的任务
社区描述
其他开发语言 Office开发/ VBA
社区管理员
  • Office开发/ VBA社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧