printing questions
client was doing all of the excel manipulation manually. i wrote code to
automate everything. now with my automated procedures, the print jobs are what holds them up. in my code i set all the print parameters for each job, and then just use: ..PrintOut Copies:=Numcop, Collate:=True now, since they have 2 printers, they want to be able to select the printer at print time and divide the jobs up. so my question a i know it's problematic trying to set up printers in code on more than 1 workstation, but should i just set up each printer on the separate workstations? they thought showing the print dialog would help, but how do i determine what pages to print, the number of copies and the ranges? or, i'll take suggestions on how to better handle this? -- Gary |
printing questions
Perhaps you could prompt the user to select the printer using this dialog:
Application.Dialogs(xlDialogPrinterSetup).Show "Gary Keramidas" wrote: client was doing all of the excel manipulation manually. i wrote code to automate everything. now with my automated procedures, the print jobs are what holds them up. in my code i set all the print parameters for each job, and then just use: ..PrintOut Copies:=Numcop, Collate:=True now, since they have 2 printers, they want to be able to select the printer at print time and divide the jobs up. so my question a i know it's problematic trying to set up printers in code on more than 1 workstation, but should i just set up each printer on the separate workstations? they thought showing the print dialog would help, but how do i determine what pages to print, the number of copies and the ranges? or, i'll take suggestions on how to better handle this? -- Gary |
printing questions
jb, looks like that may do the trick, thanks.
i didn't want to show the print dialog -- Gary "JMB" wrote in message ... Perhaps you could prompt the user to select the printer using this dialog: Application.Dialogs(xlDialogPrinterSetup).Show "Gary Keramidas" wrote: client was doing all of the excel manipulation manually. i wrote code to automate everything. now with my automated procedures, the print jobs are what holds them up. in my code i set all the print parameters for each job, and then just use: ..PrintOut Copies:=Numcop, Collate:=True now, since they have 2 printers, they want to be able to select the printer at print time and divide the jobs up. so my question a i know it's problematic trying to set up printers in code on more than 1 workstation, but should i just set up each printer on the separate workstations? they thought showing the print dialog would help, but how do i determine what pages to print, the number of copies and the ranges? or, i'll take suggestions on how to better handle this? -- Gary |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com