Powerpoint Access VBA

Question

From Access how do I work with an active i.e. open presentation?

I know how to create a new presentation with VBA in Access e.g. 

Dim ppObj As PowerPoint.Application

Dim ppP As Object

    Set ppObj = New PowerPoint.Application

    Set ppP = ppObj.Presentations.Add

But, how do I gather information or make changes to an open presentation?

Answer 1

This is certainly possible. I have done this myself where we created a slide show with images based on the results of a survey. I loved working on that project.

Forget about "as object" (and CERTAINLY forget about mixing the two); use early binding exclusively, so you get intellisense.

Record small macros in PP and check what was recorded. For example you can turn on the recorder, add the first slide, and stop.

Answer 2

This is more a Powerpoint question not an Access question. When you use Office Automation to control another VBA compliant app you are writing code compatible with that application. So if you want to know how to use VBA with Powerpoint I would suggest reposting in a Powerpoint forum.