|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
回复 313楼 yuanzhuping 的帖子
自动插入图片的情况下,让该图片在此单元格中自动居中代码应该如何写?请求指点,我尝试定义一个新的shapes变量,但是不知道如何让对应的图片赋值。
下面是微软提供的一个方案,但是提示找不到slide
Sub ImportPictureAtSize()
Dim oSlide As Slide
Dim oPicture As Shape
' Change slide index position to the first slide
ActiveWindow.View.GotoSlide 1
' Set oSlide to the first slide in the presentation.
Set oSlide = ActiveWindow.Presentation.Slides(1)
' Set oPicture to the picture file on your computer. Set Link To
' File to false, Save With Document to true, and place it in the
' upper left-hand corner of the slide, sized to 1 by 1 points.
'
' NOTE: Before you run this code replace this text string:
' "Put image path here!"
' with the path to the image you want to import. For example:
' "c:\MyImage.bmp"
Set oPicture = oSlide.Shapes.AddPicture("Put image path here!", _
msoFalse, msoTrue, 1, 1, 1, 1)
' Now scale the picture to full size, with "Relative to original
' picture size" set to true for both height and width.
oPicture.ScaleHeight 1, msoTrue
oPicture.ScaleWidth 1, msoTrue
' Move the picture to the center of the slide. Select it.
With ActivePresentation.PageSetup
oPicture.Left = (.SlideWidth \ 2) - (oPicture.Width \ 2)
oPicture.Top = (.SlideHeight \ 2) - (oPicture.Height \ 2)
oPicture.Select
End With
End Sub |
|