| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print pooling
Hi
I am redrafting my previous question as I did not get any reply for my earlier question. I have a database of 3000 employees in excel work sheet for monthly pay roll processing I have another sheet where I have designed desired pay slip format in multilanguage. I have a macro which advances the database records and prints 3 payslips per A4 sheet. The problem is My excel pools all the data into printer immediately, but printer treats every page as fresh print job and takes much time to process, as it process every page for 2-3 seconds and then prints it takes nearly 4-5 hours to complete the database is there any solution for this, where all the pages can be treated as single print job? If you wish to see the file kindly let me know where I can post my excel sheet. Try to give excel based solution as I am not a professional VB programmer, even though my knowledge is reasonably good Best Regards |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print pooling
Kiran, are you saying the sheet with the payslips (the Excel sheet, not the
printed page) has only 3 payslips on it? If so, then why not process 30 at a time, with page breaks in-between? James "kiran kumar" wrote in message oups.com... Hi I am redrafting my previous question as I did not get any reply for my earlier question. I have a database of 3000 employees in excel work sheet for monthly pay roll processing I have another sheet where I have designed desired pay slip format in multilanguage. I have a macro which advances the database records and prints 3 payslips per A4 sheet. The problem is My excel pools all the data into printer immediately, but printer treats every page as fresh print job and takes much time to process, as it process every page for 2-3 seconds and then prints it takes nearly 4-5 hours to complete the database is there any solution for this, where all the pages can be treated as single print job? If you wish to see the file kindly let me know where I can post my excel sheet. Try to give excel based solution as I am not a professional VB programmer, even though my knowledge is reasonably good Best Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to hide rows with a certain cell empty then set print area and print | Excel Programming | |||
| cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| SQL Server Connection Pooling | Excel Programming | |||
| Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook | Excel Programming | |||
Hybrid Mode
