Printing to multiple printers

[bhaineo]

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

 

[Andrew Poulsom]

Welcome to MrExcel.

Have you tried recording a macro while printing manually?

 

[bhaineo]

Here's what the macro records... I am using Office 2010 while most of the systems are Office 2007...

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