Word 批量插入图片和图片名
Word 中实现批量插入图片和自动复制图片名
使用时记得第五行的把工作路径换一下,
Sub 批量插入图片() Dim myfile As FileDialog Set myfile = Application.FileDialog(msoFileDialogFilePicker) With myfile .InitialFileName = "E:\工作文件" '这里输入你要插入图片的目标文件夹 If .Show = -1 Then For Each Fn In .SelectedItems Selection.Text = Basename(Fn) '这两句移到这里 Selection.EndKey If Selection.Start = ActiveDocument.Content.End - 1 Then '如光标在文末 Selection.TypeParagraph '在文末添加一空段 Else Selection.MoveDown End If Set MyPic = Selection.InlineShapes.AddPicture(FileName:=Fn, SaveWithDocument:=True) '按比例调整相片尺寸 WidthNum = MyPic.Width c = 18 '在此处修改相片宽,单位厘米 MyPic.Width = c * 28.35 MyPic.Height = (c * 28.35 / WidthNum) * MyPic.Height If Selection.Start = ActiveDocument.Content.End - 1 Then '如光标在文末 Selection.TypeParagraph '在文末添加一空段 Else Selection.MoveDown End If Next Fn Else End If End With Set myfile = Nothing End Sub Function Basename(FullPath) '取得文件名 Dim x, y Dim tmpstring tmpstring = FullPath x = Len(FullPath) For y = x To 1 Step -1 If Mid(FullPath, y, 1) = "\" Or _ Mid(FullPath, y, 1) = ":" Or _ Mid(FullPath, y, 1) = "/" Then tmpstring = Mid(FullPath, y + 1) Exit For End If Next Basename = Left(tmpstring, Len(tmpstring) - 4) End Function
Ref:https://zhidao.baidu.com/question/1674423237377220667.html