|
以下代码的问题在哪?老是报错说,说选择对象
Sub 宏1()
Dim pptApp As PowerPoint.Application
Dim pptPresen As PowerPoint.Presentation
Dim pptSlide As PowerPoint.Slide
Dim strTemp As String
On Error GoTo errHandle
strTemp = "C:\Users\z305204\Desktop" & "\演示文稿1.potx"
Set pptApp = New PowerPoint.Application
Set pptPresen = pptApp.Presentations.Add(msoTrue)
pptApp.Visible = True
pptApp.Presentations.Open "C:\Users\z305204\Desktop\" & "演示文稿1.potx"
'pptPresen.ApplyTemplate filename:=strTemp
Set pptSlide = ActivePresentation.Slides.AddSlide(1, ppLayoutAndTitle)
With pptSlide.Shapes.Title.TextFrame.TextRange.Text = Range("B2")
End With
With pptSlide.Shapes.Placeholders(2).TextFrame.TextRange.Text = Range("B3")
End With
Set pptSlide = pptPresen.Slides.AddSlide(1, ppLayoutAndText)
With pptSlide.Shapes.Placeholders(1).TextFrame.TextRange.Text = Range("B4")
End With
With pptSlide.Shapes.Placeholders(2).TextFrame.TextRange.Text = Range("B5")
End With
Set pptSlide = pptPresen.Slides.AddSlide(1, ppLayoutAndText)
With pptSlide.Shapes.Placeholders(1).TextFrame.TextRange.Text = Range("B6")
End With
With pptSlide.Shapes.Placeholders(2).TextFrame.TextRange.Text = Range("B7")
End With
pptPresen.SaveAs filename:="G:\test.pptx"
pptPresen.Close
pptApp.Quit
errExit:
Set pptSlide = Nothing
Set pptPresen = Nothing
Set pptApp = Nothing
Exit Sub
errHandle:
MsgBox Err.Description
Resume errExit
End Sub |
|