Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I open a Print Dialogue box through vba?

Status
Not open for further replies.

mrbud1972

Instructor
Aug 26, 2003
43
GB
How do I open a standard Print Dialogue box through vba?
Its only so the user has the option to change the printer.
(Its within Powerpoint 97)
I cannot find the script anywhere.. i'm sure it must be easy.
Ta very much

Martin.
 
dlgAnswer = Application.Dialogs(xlDialogOpen).Show


Will open the open dialog box (from the help)

Try

dlgAnswer = Application.Dialogs(xlDialogPrint).Show
 
Hi, thanks for your reply. Ive seen a variation of your post in various places however unfortunately it says Can't find project or library. Just to re-confirm, this is with Powerpoint 97.
Thanks. Martin.
 
You probably need to reference the Microsoft VB Printer Dialog(PSS) (vbPrnDlg.dll)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top