Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing to Local Printer and the not the default printer.
Can someone help me in the code of sending my sheet to a local printer
and not the default printer which is our network printer. Users need to send to the local printer, but the network is their default and we don't want them making changes to their default printer. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing to Local Printer and the not the default printer.
On 13 ruj, 14:53, wrote:
Can someone help me in the code of sending my sheet to a local printer and not the default printer which is our network printer. Users need to send to the local printer, but the network is their default and we don't want them making changes to their default printer. Thanks Sub your_printing Dim defPrinter As String defPrinter = Application.ActivePrinter Application.ActivePrinter = "YOUR_LOCAL_PRINTER" '- this is a name of your local printer 'Your source for printing '.... '.... Application.ActivePrinter = defPrinter End sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
Printer Multiple Worksheets with a particular Printer Setting | Excel Worksheet Functions | |||
Printing from default printer | Excel Discussion (Misc queries) | |||
Send printer escape commands to a printer using VBA | Excel Programming | |||
Default printer | Excel Programming |