Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Print to a specific bin
Can you define a print driver for each person so it will print to their
specific bin. Then you could put code in the templete to use that print driver using the ActivePrinter property. Otherwise, you have long row to hoe: from a previous post: Search Result 2 From: Tom Ogilvy ) Subject: Controlling two different printer trays View: Complete Thread (2 articles) Original Format Newsgroups: microsoft.public.excel.programming Date: 2003-07-13 21:47:34 PST You have to use the Windows API to do it. Here is a discussion on setting such as this: http://www.microsoft.com/accessdev/a...0.htm?&gssnb=1 Regards, Tom Ogilvy -- Regards,Tom Ogilvy"Dottie" wrote in message ... We have a template that is used by everyone at the office and each person has a bin assigned to them on the printer. Is there a way to create a macro so that this template (document) will print out of the correct bin instead of defaulting to the top bin? We are using Windows 2000, and Office 2000. Thank you in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Print to a specific bin
Thank you, I am new to all of this how would I define a
print driver for each person. And how would I put the code in the template to use that print driver? Thank you again. -----Original Message----- Can you define a print driver for each person so it will print to their specific bin. Then you could put code in the templete to use that print driver using the ActivePrinter property. Otherwise, you have long row to hoe: from a previous post: Search Result 2 From: Tom Ogilvy ) Subject: Controlling two different printer trays View: Complete Thread (2 articles) Original Format Newsgroups: microsoft.public.excel.programming Date: 2003-07-13 21:47:34 PST You have to use the Windows API to do it. Here is a discussion on setting such as this: http://www.microsoft.com/accessdev/a.../getzch10.htm? &gssnb=1 Regards, Tom Ogilvy -- Regards,Tom Ogilvy"Dottie" wrote in message ... We have a template that is used by everyone at the office and each person has a bin assigned to them on the printer. Is there a way to create a macro so that this template (document) will print out of the correct bin instead of defaulting to the top bin? We are using Windows 2000, and Office 2000. Thank you in advance. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to autofill from a specific row to a specific row | Excel Discussion (Misc queries) | |||
specific macro on specific sheets | Excel Discussion (Misc queries) | |||
print button macro & specific tabs to print | Excel Worksheet Functions | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
print a specific area within a worksheet by clicking on print? | Excel Worksheet Functions |