manipulating PowerPoint

[raymond3090]

Can anyone tell me how I can add new slides to a new PowerPOint presentation using my Access 97 code?

It seems like it would be easy in 2000+, but I can't figure it out in 97. It has to be possible!!


regards,
ray

 

[Travis]

See Microsofts Knowledge base article:

ACC: How to Create a PowerPoint Presentation Using Automation
ID: Q160822

 

[raymond3090]

thanks, that's pretty much what I've been trying to do (I actually want to do it in Excel but figured that Access would be the same thing).

I get an 'invalid enumeration error' on the .slides.add part with the following code:


Dim ppObj As Object, ppPres As Object

Set ppObj = CreateObject("PowerPoint.Application")
Set ppPres = ppObj.Presentations.Add

With ppPres
.Slides.Add 1, ppLayoutTitle
End With

Shouldn't this add a new slide?

-ray

 

[raymond3090]

nevermind, disregard the above reply. Figured it out. If I had read the Knowledge Base content closely enough I would have known that I had to add the PowerPoint library (if anybody's wondering!).

Thanks Travis for the help.

-ray