Can Excel memorise the last printer used?

S

Simon Wong

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
 
B

Bob Phillips

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of scanned file storage based on content 0
Resizing/Rescaling an Org Chart 0
Problem with margins while printing via network 0
My computer will print from ALL other programs except MS publisher 2007 4
Printing Problem in Excel 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Default printer 3
Excel 2003 loses selection of printer 0

Top