View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
David C. David C. is offline
external usenet poster
 
Posts: 30
Default Printing worksheet with printer tray # 3

as you said: keep Kool ! sometimes it is ok this way...

if it doesn't then you'll need to take a look on this: (i used it, it
works)

Don't be afraid, everything is written and you can download the macros at
the end of the last pages...
and it's easy to use it; but it takes so long to explain how it works...


Controlling the Printer from Word VBA
by Jonathan West

Part 1: Using VBA to Select the Paper Tray
http://pubs.logicalexpressions.com/P...cle.asp?ID=101

Part 2: Using VBA to control Duplex, Color Mode and Print Quality
http://pubs.logicalexpressions.com/P...cle.asp?ID=116

Part 3: Dealing with Different Paper Sizes
http://pubs.logicalexpressions.com/P...cle.asp?ID=132

Part 4: Getting printer driver details
http://pubs.logicalexpressions.com/P...cle.asp?ID=183