Microsoft Office Forums - View Single Post - [Solved] Print preview and print dialog

Thread: [Solved] Print preview and print dialog

View Single Post

Old

07-21-2020, 03:49 PM

trevorc

trevorc is offline

trevorc uses Windows 7 32bit

Windows 7 32bit trevorc uses Office 2013

trevorc uses Office 2013

Office 2013

Competent Performer

The original poster

Join Date: Jan 2017

Posts: 174

trevorc will become famous soon enough

trevorc will become famous soon enough

Default

I did it.

I used this to select the printer then display the print and print preview dialog
It changes the active printer, then the command bar exe will show the correct printer i need.

Code:

   t = Application.Dialogs(xlDialogPrint).Application
    Application.CommandBars.ExecuteMso ("PrintPreviewAndPrint")

Reply With Quote