View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tp@mrsupply.se is offline
external usenet poster
 
Posts: 4
Default Print with paper from a specific printer-tray

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