Print preview and print dialog

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Print preview and print dialog

FAQ

Thread Tools

Display Modes

07-21-2020, 03:49 PM

trevorc

Windows 7 32bit Print preview and print dialog

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

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")

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Print and print preview move graphics	Aviendah	Word	1	10-06-2016 08:36 AM
Discrepancy between Weeknumber i nOnscreen Gantt Chart and print/print preview	deesloop	Project	7	07-22-2015 07:52 AM
I cannot get print layout to match print preview	survivo01	Word	4	05-22-2014 12:57 AM
Print Layout View Differs from Print Preview & Printed Document	terik222	Word	3	03-27-2013 02:43 PM
Print preview and actual print do not match?	anthrax19888	Word	1	10-12-2009 08:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:00 AM.