hello,
i need to setup a macro (in excel 2007) which allows me to print to a non-default printer and so that page 1 prints in tray 3 and the remaining pages print to tray 4 (headed and continuation paper)
I've found this macro:
Sub HPPrintTray2()
Dim sCurrentPrinter As String
Dim sTray As Integer
sCurrentPrinter = ActivePrinter
sTray = Options.DefaultTrayID
ActivePrinter = "HP LaserJet 4050 Series PS"
With Options
.DefaultTrayID = 260
End With
Application.PrintOut FileName:=""
With Options
.DefaultTrayID = sTray
End With
ActivePrinter = sCurrentPrinter
End Sub
which seems to work fine for 1 tray, but i think i need to amend it somehow with the following:
.FirstPageTray = 259
.OtherPagesTray = 260
can anyone show me how to successfully combine the two?!
Many thanks
Bookmarks