Thread
:
Print with paper from a specific printer-tray
View Single Post
#
3
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 4
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.
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]