Duplex Printing

[Ron Dahl]

Is it possible to turn duplex printing off or on using VBA code? If so,
could someone give me a few tips for where to look on how it is done?
Thanks in advance for any help.
Ron

 

[Tom Ogilvy]

You can start reading here:


http://www.microsoft.com/accessdev/articles/getzch10.htm?&gssnb=1


and here


http://support.microsoft.com/default.aspx?scid=kb;en-us;230743
HOWTO: Set Duplex Printing for Word Automation

Neither one of these is totally applicable for doing it from Excel, but you
should be able to adapt the second (which manages word from VB) to do what
you want I would think.



Regards,
Tom Ogilvy