爱疯 发表于 2016-5-4 14:27
只看图,难猜原因,建议上传文档
Sub pic_insert() If Trim(path_str) = "" Then path_str = InputBox("请输入图片服务器路径:" & Chr(13)& Chr(10) & "例如:D:\图片\","picture_path") End If On Error Resume Next Dim MR As Range For Each MR In Selection IfNot IsEmpty(MR) Then MR.Select ML = MR.Left MT = MR.Top MW = MR.Width MH = MR.Height ActiveSheet.Shapes.AddShape(msoShapeRectangle, ML, MT, MW, MH).Select Selection.ShapeRange.Fill.UserPicture _ path_str & MR.Value & ".jpg" End If Next End Sub
这是不显示图片的文档和用到的代码,还请看看是什么原因导致的不显示图片{:1612:}
|