Thread: Print with paper from a specific printer-tray
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
davegb davegb is offline
external usenet poster
  
Posts: 573
Default Print with paper from a specific printer-tray

wrote:
Hi,
when I use Excel with VBA and record a macro to select a printer the result
is like this:

Application.ActivePrinter = "\\SWLJUNFS\Ljungby_1 on Ne03:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"\\SWLJUNFS\Ljungby_1 on Ne03:", Collate:=True

but I like to use the lower paper-tray. How to solve it?

Torbjörn Pettersson, Sweden

Record the macro, but change the paper tray while recording it. You'll
be able to see the difference in the code and copy it to your code.

Reply With QuoteReply With Quote