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

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.

--
HTH

Bob Phillips

"Simon Wong" wrote in message
...
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