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

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