PDA

View Full Version : Powerpoint vba to print ONLY the comments!!!



chris italy
03-03-2010, 10:09 AM
Hi, I am now trying to print out just the comments from a page - ie look at a screen advertising a zoo, click an icon to print out the address and opening times...

I am trying

Sub PrintPresentationComments()
With ActivePresentation
.PrintOptions.OutputType = ppPrintOutputNotesPages
.PrintOut
End With
End Sub

or

With Application.ActivePresentation
With .PrintOptions
.PrintHiddenSlides = False
.FitToPage = True
.PrintComments = True
.FrameSlides = False
.PrintInBackground = False
End With
.ppPrintOutputNotesPages
End With
End Sub

but both of these print the slide aswell.

Am I missing something that should be set to false so just the comments are printed on their own?

As a side thought, it would be handy if i can print a graphic logo on the header of the notes...does this men i should perhaps abandon the notes idea and create a second page with the graphic and the info, then print that entire slide instead????

thanks lots
chris

Paul_Hossler
03-04-2010, 04:24 PM
Always a good source. Try this to see if it's what youlre looking for

http://pptfaq.com/FAQ00481.htm

Paul

chris italy
03-05-2010, 06:08 AM
Hi, thanks for this - i have checked this already and i think it has more user-input than i can allow....in fact i can only allow a single click. This is to run on a touch screen kiosk.

I have opted, i think, for a print screen method, but print next screen rather than current so i can totally control content.

The only downside is that if this exists 10 times in a 100 page show, i can not see a way of writing a single macro to 'print next page', so it looks like i will need a separate macro for each instance and hard code the page number i need to print. Also this means that if i add a page anywhere, all print macros after that page must be amended....

If anyone knows how to 'print next slide' i would be grateful to hear it!

Easy concepts.....pig difficult realisations! life hey....

chris italy
03-05-2010, 07:09 AM
$%&^*^%$£&%$£!!!!!

powerpoint viewer does not run macros!!!!!

How am i going to run this on 4 kiosks without macros?????????????
oh, how annoyed am I???