Printing Problem

Kevali

New Member
Joined
Aug 21, 2006
Messages
15
I have a spredsheet that prints either a single, double or triple sheet report dependent on user selection via a userform.

The problem I have is with selecting a printer, in the office we have a networked A4 mono and A3 colour laser printers and a networked Photocopier that can be used as a A4/A3 printer Stapler etc


1. How do I get a list of the all the installed printers on a system? I suspect an API call but do not know which one.

2. How do I change the activeprinter - if needed ?

3 How do I alow the user to make any changes in the print driver i.e print duplex?

Finally I think then my print routine can kickin dependednt on the options the user has set in the epreadsheet.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,141,140
Messages
5,704,522
Members
421,353
Latest member
jekoxien15

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
Top