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.
 

Some videos you may like

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.

Watch MrExcel Video

Forum statistics

Threads
1,109,446
Messages
5,528,802
Members
409,836
Latest member
karnasrinivas
Top