MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Printing Prob

Posted by Expresso on July 28, 2001 4:08 PM

Hi, I use excel at work to store data and produce a range of docs to customers...We keep file copies so I need one on letterhead and one on plain paper - is there anyway of swapping the paper trays using vb in excel? I cant seem to record, or find an action to swap paper trays during print routines.

Thanks in advance for any help.

Posted by steve w on July 28, 2001 8:10 PM

How do you swap trays now tell me al of the steps in order.

Posted by steve w on July 28, 2001 8:44 PM