How to do I Select a Printer Profile via VBA when printing

Tigs81

Board Regular
Joined
Mar 10, 2011
Messages
70
Hi All

I am wondering if it is possible to select a specific printer profile when printing, instead of just having to use the default option when printing to a specific printer?

If it is how would i do this?

any help would be greatly appreciated.

Thank you
Tigs
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Im not sure if thats possible, but i think you can change the setting when you press print.

Maybe you could recreate the profile... like print from tray 3 and on two side... that kind of thing.
 
Upvote 0
Thank you

I am trying to get the printer to print 5 pages stapled and then print 2 not then print 5 stapled etc as it goes through a 2000 page document.

My first thought was to print to two different printers one with the stapled printer profile set as default and the other printer with it not (both pointing to the same physical printer). Then print to them alternating.
The problem is that they documents have some of the groups of pages out of order.

So i am thinking that the only way to do this is to change the printer profile in the same printer to allow for the documents to queue correctly.

But i dont know how to change the printer profile andi am not aware of another way to turn on and off page stapling.

Thanks
Tigs.
 
Upvote 0

Forum statistics

Threads
1,224,586
Messages
6,179,728
Members
452,939
Latest member
WCrawford

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top