I can't seem to be able to save the print settings on a template we use
for generating invoices.

I need the Printer's own properties saved within the template, so these
are always the default when the template is opened (i.e the properties
accessed via FilePrintProperties - not Excel settings like print
margins etc)

We use the Xerox C226 workcentre and the default required is simply
that it prints from tray 1. We do not want this the default tray for
other applications however, just for this particualr document.

Any ideas? I've tried recording macros but it won't record the
properties, only page copies, collating etc.

Any help much appreciated
Thanks
Alex


--
alex3867
------------------------------------------------------------------------
alex3867's Profile: http://www.excelforum.com/member.php...o&userid=37220
View this thread: http://www.excelforum.com/showthread...hreadid=573047