Can Excel memorise the last printer used?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon Wong - 25 Apr 2005 03:19 GMT

My problem is
I have 2 network printers, A and B, A is set to be the default printer.
I work on an Excel doc and choose B to print out.
I want to know how to make this file to memorise the last used printer B so
that next time I open the file it use printer B automatically.

My software is Excel 2003 on WinXP (SP2)

Best regards
Simon Wong

Reply to this Message

Bob Phillips - 25 Apr 2005 10:43 GMT

You would probably need to write code to select the printer, save that info
in the workbook, output to that printer, and reset it on next opening.
Hardly seems worth the effort to me.

Signature

HTH

Bob Phillips

> My problem is
> I have 2 network printers, A and B, A is set to be the default printer.
[quoted text clipped - 6 lines]
> Best regards
> Simon Wong

Reply to this Message