View Single Post
  #3   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

Sorry, I tried that but I couldn't see ny difference. The information about
the the tray were not recorded.

"davegb" skrev:


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.