Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello-
Is it possible to specify the manual feed tray when using the printout method? -- Thanks, Mike |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Mike
No not using that method my guess is your going to have to pull printer information and write it back using an API Call try here for a nice list of API calls http://www.mentalis.org/apilist/apilist.php -- When you lose your mind, you free your life. "Mike Archer" wrote: Hello- Is it possible to specify the manual feed tray when using the printout method? -- Thanks, Mike |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Mike,
Have you tried using SENDKEYS to specify settings for your printer? These work to alter the portrait/landscape simplex/duplex settings on my LaserJet5SI. %FU is the same as Alt-F (File) Setup In the first example, %O is Alt-O (Options) then you just add whatever letters you'd have to type to do the job manually. Hope this helps Pete Sub PrinterSetupPortraitDuplex() SendKeys "%FU%O%RD~~" End Sub Sub PrinterSetupLandscapeDuplex() SendKeys "%FU%O%LT~~" End Sub Sub PrinterSetupPortraitSimplex() SendKeys "%FU%O%RN~~" End Sub Sub PrinterSetupLandscapeSimplex() SendKeys "%FU%O%LN~~" End Sub "Mike Archer" wrote: Hello- Is it possible to specify the manual feed tray when using the printout method? -- Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
Print with paper from a specific printer-tray | Excel Programming | |||
Send printer escape commands to a printer using VBA | Excel Programming | |||
Printing worksheet with printer tray # 3 | Excel Programming | |||
Use VBA to access Printer Properties (Resolution, Tray etc) | Excel Programming |