How to create a Print Macro that selects a printer

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

I've created a command button to print a one page
presentation that will be distributed in slideshow .pps
format.

Using "ActivePresentation.PrintOut" works well, however
it only prints to the active printer.

I'm looking for any code that would instead call up the
Print dialog box so the user can select the printer they
desire (some may want to print to a color printer, others
black and white).

Any ideas?
 
I've created a command button to print a one page
presentation that will be distributed in slideshow .pps
format.

Using "ActivePresentation.PrintOut" works well, however
it only prints to the active printer.

I'm looking for any code that would instead call up the
Print dialog box so the user can select the printer they
desire (some may want to print to a color printer, others
black and white).
Click to expand...

Google on terms like "vb enumerate printers"
That should land you on some code that allows you to build your own list of
installed printers; with that you can build a userform that lists the printers
and lets the user select the one they want.

I'd actually start by going to http://www.mvps.org and following the link to
Randy Birch's VB.net site - I'm almost positive there's a well-commented bit of
code there to do this.
 
Sub printout()
'Fires Print dialog to choose the printer
'Works in SlideShow view as well
CommandBars("File").Controls("Print...").Execute
End Sub

This opens the Normal View and the Print dialog. After printing just
minimize this view and Slide Show is still running.

Brian Reilly, PowerPoint MVP
 
Back
Top