我正在编写一个宏,该宏将创建PowerPoint演示文稿,然后从电子表格中复制数据,并添加标题和文本框。我已经能够添加数据以及平铺和格式化两者,但是我正努力添加文本框。当我运行下面的代码时,它返回错误“ ActiveX组件无法创建对象”。我感觉就像在看简单的东西。任何帮助将不胜感激!(在第一组“ -------”之后的行上发生错误)
Sub Create_Presentation()
Dim rng As Range
Dim PowerPointApp As PowerPoint.Application
Dim myPresentation As PowerPoint.Presentation
Dim mySlide As PowerPoint.Slide
Dim myShape As PowerPoint.Shape
Dim myTextbox As Shape
On Error Resume Next
Set PowerPointApp = CreateObject(class:="PowerPoint.Application")
Err.Clear
If PowerPointApp Is Nothing Then Set PowerPointApp = CreateObject(class:="PowerPoint.Application")
If Err.Number = 429 Then
MsgBox "PowerPoint could not be found, aborting."
Exit Sub
End If
On Error GoTo 0
Application.ScreenUpdating = True
Set myPresentation = PowerPointApp.Presentations.Add
Set mySlide = myPresentation.Slides.Add(1, 11) '11 = ppLayoutTitleOnly
Set rng = Range("PL_Tot")
rng.Copy
mySlide.Shapes.PasteSpecial DataType:=xlBitmap
Set myShape = mySlide.Shapes(mySlide.Shapes.Count)
myShape.Left = 0.3
myShape.Top = 67
myShape.Width = 430
myShape.Height = 406.4
mySlide.Shapes.Title.TextFrame.TextRange.Text = Range("TotalTitle").Value
Set sldTitle = mySlide.Shapes.Title
With sldTitle
With .TextFrame.TextRange
With .Font
.Bold = msoTrue
.Size = 22
.Color = RGB(0, 0, 200)
End With
End With
End With
sldTitle.Top = -30
'------------------------------------
Set myPresentation = ActivePresentation
Set mySlide = myPresentation.Slides(1)
Set myTextbox = mySlide.Shapes.AddTextbox(msoTextOrientationHorizontal, _
Left:=0, Top:=10, Width:=200, Height:=50)
With myTextbox.TextFrame.TextRange
.Text = Range("PPTextbox").Value
With .Font
.Size = 12
.Name = "Arial"
End With
End With
'-----------------------------------
PowerPointApp.Visible = True
PowerPointApp.Activate
Application.CutCopyMode = False
Excel和PowerPoint都可以具有Shape对象。你的:
Dim myTextbox As Shape
准备Excel以期望Excel形状。更改为
Dim myTextbox As PowerPoint.Shape
因此,当您尝试将PowerPoint属性和方法应用于Excel形状时,Excel不会吠叫。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句