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. |
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. . |
All times are GMT +1. The time now is 12:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com