|
楼主 |
发表于 2012-7-1 21:26
|
显示全部楼层
Sub 按照当前行A列的图片名称插入图片到H列()
On Error Resume Next
Shapes.Delete
For aaa = 0 To 10 'Step 2
Range("H" & (aaa)).Select
ActiveSheet.Pictures.Insert(ThisWorkbook.Path & "\" & Range("B" & aaa) & "\" & Range("A" & Selection.Row) & ".JPG").Select
Selection.ShapeRange.LockAspectRatio = msoTrue
Selection.ShapeRange.Height = 84.75
Selection.ShapeRange.Width = 150.75
Selection.ShapeRange.Rotation = 0#
Selection.ShapeRange.ScaleWidth 0.73, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.73, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 5, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.25, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleWidth 1, msoFalse, msoScaleFromTopLeft
Range("A" & aaa).Select
Next aaa
End Sub
这个好象是你写的哦,那要怎样固定图片大小啊,最好是随图片所在的单元格多少一样 |
|