Printing to multiple printers

bhaineo

New Member
Joined
Sep 2, 2011
Messages
4
Hi,

I need some help writing a macro for printing.

My excel file for generating a Purchase Order is like this:

Sheet 1: User fills in all the data. Also has a command button for print.
Sheet 2: (Hidden) Takes data from sheet 1 and formatted for printing (zoom, print areas, margins etc are set).

On pressing command button on sheet 1, i want Sheet 2 to be printed first using CutePDF (installed as a printer) to create a PDF and then printing 2 copies on an HP printer. Can we select the printer and number of copies using code?

Thanks,
Neo
 

bhaineo

New Member
Joined
Sep 2, 2011
Messages
4
Here's what the macro records... I am using Office 2010 while most of the systems are Office 2007...

Code:
    Sheets("POPrint").Select
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
        IgnorePrintAreas:=False
    ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True, _
        IgnorePrintAreas:=False
    Sheets("POData").Select
 
Last edited:

Forum statistics

Threads
1,082,569
Messages
5,366,360
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top