Solved

How to run a Powerpoint presentation within Powerpoint

Posted on 2014-02-05
3
687 Views
Last Modified: 2014-03-31
Hi,

My requirement is to have a Powerpoint presentation run in jhe background of a work canteen.  I want to  put files (Powerpoints and image files) in a particular folder and have Powerpoint loop thru and open each file, import and display them in a looping slideshow.

Everynow and again different files will be placed in the folder and I want to dynamically insert them into my looping presentation.

I'd expect this to be done through VBA coding.  I am experienced in Excel & Access with VBA coding but not with Powerpoint.

Has anyone done anything similar in the past?

Thanks
0
Comment
Question by:adb11a
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39838079
Hi,

Pls try this youhave to build the loop to repeat the whole procedure

Function RunPresentation(strFolderAndFile As String)

Set oPres = Application.Presentations.Open(strFolderAndFile)

oPres.Slides.Range.SlideShowTransition.AdvanceOnTime = True
oPres.SlideShowSettings.AdvanceMode = ppAdvanceOnTime
oPres.SlideShowSettings.ShowType = ppShowTypeKiosk

oPres.SlideShowSettings.StartingSlide = 1
oPres.SlideShowSettings.EndingSlide = oPres.Slides.Count

Set objSlideShow = oPres.SlideShowSettings.Run.View

Do Until objSlideShow.State = ppSlideShowDone
    If Err <> 0 Then
        Exit Do
    End If
Loop
oPres.Saved = True
oPres.Close


End Function

Sub LoopThrougFiles()
    MyFile = Dir(CurDir() & "\" & "*.ppt*")
    Do While MyFile <> ""
        theFile = Dir()
        RunPresentation (curDir() & "\" & theFile)
    Loop
End Sub

Open in new window

0
 

Author Comment

by:adb11a
ID: 39848871
Thanks Rgonzo1971,

I was able to use this method to get me started. Well done!
0
 

Author Comment

by:adb11a
ID: 39967866
I've requested that this question be closed as follows:

Accepted answer: 0 points for adb11a's comment #a39848871

for the following reason:

Got me started...
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question