Print PP pres from Access

M

Maarkr

my code doesn't always do what I want...
I want to print preview a presentation from within Access:

Private Sub CmdPrint1_Click()
Dim pres As PowerPoint.Presentation, stPath As String

stPath = "S:\Training\Compliance-20090715.pptx"

Set myPP = New PowerPoint.Application
myPP.WindowState = ppWindowMinimized
Set pres = myPP.Presentations.Open(stPath)
pres.PrintOut
pres.Close
Set myPP = Nothing

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Powerpoint pres 1
Another problem..Open pps from form 1
Automation from Access 1
Adding music from file corrupts my PP pres. How do I fix? 0
Accessing chart in VBA 1
Access to PPoint / Determining SHAPE (INDEX) w/VBA 4
VBA Q: syntax to paste special in PP from XL? 1
How to copy multiple objects from Excel to PowerPoint 0

Top