I know how to select whatever printer I want in excel to print. However, some of my excel sheets require a different paper size. So is there a way to set printer preferences using vb code in excel.
I tried to record a Macro selecting the printer, selecting printer properties, selecting printer preferences, and then change the size. When I viewe the macro, it only shows the printer selection but not the other changes.
This is a label printer and I still have to manually change out the label roll from 4 x 6 default to 4 x 4. It looks like I will have to change the printer preferences manually also.
Thanks for any ideas
Todd
I tried to record a Macro selecting the printer, selecting printer properties, selecting printer preferences, and then change the size. When I viewe the macro, it only shows the printer selection but not the other changes.
This is a label printer and I still have to manually change out the label roll from 4 x 6 default to 4 x 4. It looks like I will have to change the printer preferences manually also.
Thanks for any ideas
Todd