Status: Solved
Priority: Medium
Security: Public
Views: 1404
Last Modified: 2016-08-15

VBA - Powerpoint create new presentation and then copy slides from another presentation

Hi guys,

I'm working on creating a tool for powerpoint where I need to create a new PPT and then paste slides ind from a PTT from a specific location.

But i'm having some issues with it, for some reason it simply just paste in the the slides into the first presentation that is open.

please advise.

this is the code I'm using:

Sub pre()

    Dim myPresentation As Presentation

    'Set myPresentation = Presentations.Add(WithWindow:=msoFalse) 'hidden
    Set myPresentation = Presentations.Add(WithWindow:=msoTrue) 'visible

        Call Module1.main

End Sub

Sub main() 

Dim objPresentation As Presentation
Dim i As Integer

'open the target presentation
Set objPresentation = Presentations.Open("c:\temp\Test import2.pptx")
For i = 1 To objPresentation.Slides.Count
    objPresentation.Slides.Item(i).Copy
    Presentations.Item(1).Slides.Paste
Next i
objPresentation.Close

End Sub

Open in new window

Hakum

Asked: 2016-08-11

Advertise Here

1 Solution

LVL 55

Rgonzo1971Commented: 2016-08-11

Hi,

pls try

Sub main()

ActivePresentation.Slides.InsertFromFile "c:\temp\Test import2.pptx", 0

End Sub

Open in new window

Regards

LVL 55

Rgonzo1971Commented: 2016-08-11

Or simply

 sTemplate = "c:\temp\Test import2.pptx"

    Set myPresentation = Presentations.Open(sTemplate, False, True, True)

Open in new window

LVL 1

HakumAuthor Commented: 2016-08-11

Whoop whoop! thanks alot! you Rock! it works!

LVL 1

HakumAuthor Commented: 2016-08-15

I'm been struggling again.. please tell me if i need to make a new question but its simply not working for me if i have more then 1 presentation.. it only add's the last presentation in that is in the code..

please advise here is the code:

Sub create_new_ppt()

    Dim myPresentation As Presentation

    Set myPresentation = Presentations.Add(WithWindow:=msoFalse) 'hidden
    'Set myPresentation = Presentations.Add(WithWindow:=msoTrue) 'visible
    
    
    'Import Presentation
    If crtppt.chk_pres1.Value = True Then
        sTemplate = "c:\test\Test import2.pptx"  '16:9 format
        'Call pres1
    End If

    If crtppt.chk_pres2.Value = True Then
        sTemplate = "c:\test\Test import3.pptx"  '4:3 format
        'Call pres2
    End If
        
        
    Set myPresentation = Presentations.Open(sTemplate, False, True, True)

End Sub

Open in new window

And here is the file i'm working with:

ppt-tool-15082016.ppt

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

VBA - Powerpoint create new presentation and then copy slides from another presentation

Join & Write a Comment Already a member? Login.

Featured Post